topic Re: Create total column in pivot table Chart in QlikView

Create total column in pivot table Chart

Fri, 17 Jan 2014 21:06:37 GMT

How do I create a Grand total column in pivot table chart? Just like a Grand total column that shows while using pivot tables in Excel.

Re: Create total column in pivot table Chart

Nicole-Smith — Fri, 17 Jan 2014 21:12:29 GMT

You should be able to get this by putting a partial sum on the first dimension in your pivot table (you can also change the label if you'd like):

Re: Create total column in pivot table Chart

Mon, 20 Jan 2014 13:16:35 GMT

Thank you for responding Nicole. But I was wanting a vertical totals column. Your suggestion above, gives me a horizontal total in a row. My BP is wanting a grand totals column.

Re: Create total column in pivot table Chart

Mon, 20 Jan 2014 13:26:29 GMT

You probably need to create a new expression. Someting like expression1 + expression2...

Re: Create total column in pivot table Chart

Mon, 20 Jan 2014 14:23:48 GMT

Nicole Smith i tried it again, and your suggestion worked. Thank you very much

Re: Create total column in pivot table Chart

Mon, 20 Jan 2014 14:25:00 GMT

Pavol Hajastek thank you for taking time to respond. for now I used Nicole Smith's suggestion. Have a great day. Appreciate your willingness to share your knowledge.