Pivot total sum and calculations

[#1]

Hi,

I am new to QlikView.

I have a pivot table where you can select products and time. I do sum/totals pr. month as the grey below.

I would like to add 1 SUM across the selected time, in yellow (e.g. for the 3 months selected below).

Later I would like to add more complex calculations e.g. growth pr. month (between the months) by calculating difference between current and previous months.

What to do?

[swuehl · Accepted solution]

You can add partial sums also to your pivoted Month dimension, go to presentation tab, select the appropriate dimension and enable 'Show partial sums' for each dimension, where needed.

To calculate growth, look into chart inter record functions, namely Above() / Below() resp. Before() / After() for pivoted dimensions.

Something like

=Sum(Value) / Before(Sum(Value)) -1

for Growth calculated respecting your pivoted Month.

[#3]

Absolutely fantastic! Thanks for the swift reply