topic Cumulative value in the pivot table? in QlikView

Cumulative value in the pivot table?

Wed, 16 Sep 2009 12:12:57 GMT

Hi All,

I want to get my Profit amount with respect to time in x axis.
But here i should get the cumulative value across months.
Let me be clear on this.

Suppose am getting my profit for Jan-2009 = 1000,
Profit for Feb - 2009 =2000 + 1000,(profit of feb + profit of jan)
So my Profit for March should be = 3000 + profit for march.
in this way my profit should be cumulated across time.

Is this possible in QV?

Thanks,
Mahasweta

Cumulative value in the pivot table?

fredericmante — Wed, 16 Sep 2009 13:42:38 GMT

Hi,

I have an old example that explains how to make a sum on a pivot.

Cumulative value in the pivot table?

Mon, 26 Oct 2009 21:40:57 GMT

This is great.

But how can you do the cumulative % version of this.

Here's what I have and it works except for the first and last row columns.

rangesum (sum([exam count]), above(sum([exam count]),1,rowno()))
/
rangesum (sum([exam count]), bottom(sum([exam count]),1,rowno()))

If I set the latter part of the function to a 0 or -1 for the bottom row, it won't work either.....

Need your help.