Above function is not working if i add more than 2 dimensions in Qliksense

[Navars]

Hello All,

I have a Table chart, in that i am passing 3 dimensions(DATE_REFRESHED, MODEL, SKU) and one measure(sum(cost)), what i need here is i need to calculate the variance of the measure compared with previous month for the same SKUs.

Sum(USD_MATERIAL_COST)-above(Sum(USD_MATERIAL_COST)) --> if i use this expression and with 2 dim. i am getting the expected result but in my case i have to use the all 3 dim.

attached the sample data (sample_data.xlsx) 

Thanks in Advance!!

[Andrea_Spinetti]

Hello @Navars, can you attach a sample Qlik Sense App where you have developed the draft of the table you are talking about? I'm struggling to understand how you compare/group the fields in your environment. Thanks!