topic Re: Total Pivot table in QlikView

Total Pivot table

emteam162 — Mon, 17 Jun 2013 16:08:42 GMT

Hi all,

I want to have the total column in my pivot table as :

A B C total

total 11 22 33 66

AA 10 20 30 60

BB 1 2 3 6

Many thanks,

Best Regards,

Emteam

Gysbert_Wassenaar — Mon, 17 Jun 2013 16:10:37 GMT

Enable Partial sums for the two dimensions of your pivot table on the Presentation tab of the properties window.

emteam162 — Mon, 17 Jun 2013 16:13:57 GMT

Hi,

I am doing that but doesn't work.

Many thanks

Emteam

emteam162 — Tue, 18 Jun 2013 08:08:38 GMT

I want in my presentation to have

A B C total

total 11 22 33 66

AA 10 20 30 60

BB 1 2 3 6

Not

total A B C

total 66 11 22 33

AA 60 10 20 30

BB 6 1 2 3

Many thanks

Emteam

Tue, 18 Jun 2013 08:44:46 GMT

in this case, manage Totals by yourself and store it as fields.

You will be then able to manage the position you want them to appear.

best regards

chris

emteam162 — Fri, 21 Jun 2013 08:53:50 GMT

Many thanks for your answer.

Best Regards,

Emteam