Accumulate Total in Pivot table

[#1]

I want accumulated total in total partial sum, Can I create Accumulated total in pivot table such as attached excel:

[#2]

Hi,

Greetings for the day.

For your query I believe this can be done by using Pivot Table in QlikView as follows:

** Create a pivot table with your requirements.

**Goto Presentation tab and select the dimensions and expressions you require (multiple).

**Click on show partial sums and apply.

**Result will be shown as given  below in a snapshot.

Hope this might be of some help to you.

Happy QlikViewing.....

Regards

Mayank

[#3]

Hi Mayank,

Thanks for your help but this is not my question look into each formula (gray highlight) in attached file.

Thanks a lot.

[#4]

Hi Imadri,

Try Rangesum function in the expression, please find the attached file, hope it helps.

[#5]

Thanks a lot, but this is not my aim i want accumulate total in partial sum total records (open attached and look into red highlighted).

Thanks and Best Regards,