Discussion Board for collaboration related to Creating Analytics for QlikView.
I want to show the accumulate by month per year in a pivot table. Is it possible? How would I accomplish this? I attached a photo of what my pivot table looks like. Basically a accumulation month over month.
So you want to accumulate across your months and not go down? Use ColumnNo() instead of RowNo() and Before/Atfer instead of Above/Below in your RangeSum() function
You can use
where - 0 is an offset and 12 is the "Counter" - assuming you want to accumulate it for 12 months. You may adjust it based on your need.
Yes I want it to accumulate across. So would I have 2 expressions? Currently I have SUM(Net Sales Amount).
Ok then use
Rangesum(before(Sum[Net Sales Amount]),0,12))
I have just given examples of Sum and Count. You can use as per your need.
You can do what jayanttibhe mentioned, or use this
RangeSum(Before(Sum([Net Sales Amount]), 0, ColumnNo()))