topic Re: Accumulate Total in Pivot table in QlikView

Accumulate Total in Pivot table

Wed, 05 Sep 2012 10:27:32 GMT

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

Wed, 05 Sep 2012 10:58:38 GMT

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

Wed, 05 Sep 2012 11:10:48 GMT

Hi Mayank,

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

Thanks a lot.

Wed, 05 Sep 2012 12:38:08 GMT

Hi Imadri,

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

Thu, 06 Sep 2012 06:47:05 GMT

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,