Price increase Total vs. average

[MichaelFL]

Hello Community,

I need your help.

In a table, I compare Price 2022 vs. 2021. The prices have been calculated as scenario in differently crazy formulas with max and mode function.

In the rows everything works. But I would like to have another value in the TOTAL Value.

Qliks output is the average of both percentage values = 13,125%.

I would like to have the price increase in relation to the volume. In other words, the price increase for the supplier. is this possible?

[vinieme12]

please post some sample data, and expected output

[MichaelFL]

Unfortunately, I cannot export Qlik data as CV .file
I have mentioend an excel example above.
Price increase in a row is (Preis2022/Preis2021)-1. The output in the row is OK.
Bute the average for TOTAL value should be 6,267% not 13,125%. (Price development for both material in relation to quantity.

[vinieme12]

Never export and post your actual data

but , you can create dummy data with dummy values that represents your dataset

[MichaelFL]

in my post are dummy data

[MichaelFL]

a small mistake in my excel file has been eliminated.