Pivot table - show value for upper level

Thu, 09 Apr 2015 11:51:22 GMT

Hi,

In a pivot table, I am trying to show, for each register, the value of the sales for the dimension above it. Here is my table:

As you can see, there is a Sales (Venta) column (first one). In the second column I want to show the total sales for the upper level dimension, and as you can see, it works perfectly. In case it is not properly readable, the formula I came up with is:

Bottom(RangeSum(Above(TOTAL Column(1), 0, RowNo()))

Now, my problem is that I need this behavior for ALL levels, and not only for the last one. As you can see, for the upper levels of the table, the value is not being shown/calculated. One more added problem is that the dimensions are variable so the structure shown can be different every time, replacing or eliminating some of the dimensions.

Is there any way to work this out?

Thank you very much!

topic Pivot table - show value for upper level in QlikView

Pivot table - show value for upper level