Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
paulyeo11
Valued Contributor III

How to add total column on pivot table ?

Hi All

I have a pivot table , which compute Exp type by month.

with michael help , i manage to display the Total Row at the top. So now i can view the month total exp amount.

Now i need to display Column total. can some one help me. So that i can display which is overall total amount on exp type for last 2 year.

Paul

11 Replies
Highlighted
Not applicable

Re: How to add total column on pivot table ?

Its same like how you did for Row..

For getting column total you have to select last dimension and tick "show partial sums"

Highlighted
paulyeo11
Valued Contributor III

Re: How to add total column on pivot table ?

Hi Kar

Thank you for your fast reply.

The issue is the check box is disable. i am not able to tick.

Paul

Highlighted
paulyeo11
Valued Contributor III

Re: How to add total column on pivot table ?

Hi Kumar & Kar

Both your advise not work.

So i believe my pivot table have some setting which make the show partial total disable.

Finally i have a another QV doc , which also have same table , and i copy to my sheet and it work fine.

Thank you

Paul

Highlighted
Not applicable

Re: How to add total column on pivot table ?

Could u give sample file?

Highlighted
paulyeo11
Valued Contributor III

Re: How to add total column on pivot table ?

Hi sir

If you want the sample file . You can download from my previous post which

Michael help me row add total amount.

Paul Yeo

TDS Technology (S) P/L

www.tdstech.com

HP +6593261804

Highlighted
Not applicable

Re: How to add total column on pivot table ?

Hi paul,

Is you want like below image?

Capture.JPG

Highlighted
paulyeo11
Valued Contributor III

Re: How to add total column on pivot table ?

Hi sir

Your image show the result is correct . How you do it . Care to give me the step ? As mine the show patial sub total check box is disable.

Highlighted
Not applicable

Re: How to add total column on pivot table ?

Hi paul,

I did which Mr. Michael told you.

" go to the tab "Style", and uncheck "indent mode".  After this, you can use "show partial sums" (Presentation tab)."

For enabling "Show Partial Sums", "Indent Mode" should be un checked.

Find attachment.

Karthik

Highlighted
paulyeo11
Valued Contributor III

Re: How to add total column on pivot table ?

Hi Sir

Can you pls tell me what is the purpose of indent mode ? Why it turn on ?

Paul Yeo

TDS Technology (S) P/L

www.tdstech.com

HP +6593261804