Function "above"

[#1]

Hi,
I have problem with function "above" in QV Pivot Table (see attachment). If I create 2 dimensions (Month+ Cusomer Name) and then create field with function "above", this function does not work as expected. Could you, please, explain how to make this function working. I expect function above (sum(SalesAmount)) for the 2'nd line should return 782.99.

Thanks,
Ramunas

[#2 · Accepted solution]

If you change the order of your dimensions (Customer_Name, Month instead of Month,customer_name) , it works.

It is because you have only one customer and the above function works on the above value of the last dimension used.

Hope that helps.

Philippe