Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need a accumulative in pivot table by line

I need design a chart with year and month as dimension accumulating sales in last column.

Looks like:

PivotTable_Accumulate_helpQlikView.png

Remember, sum need be only the last column.

How can i do this?

Thks for advice!

3 Replies
Gysbert_Wassenaar

On the Presentation tab select the Month dimension enable Show Partial Sums for that dimension.


talk is cheap, supply exceeds demand
jvitantonio
Luminary Alumni
Luminary Alumni

Please check app attached.

Not applicable
Author

Nice!

Now, how can i get this value and compare with sum(sales) from current year?

PivotTable_Accumulate_helpQlikView_2.png