Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Not applicable

Its same like how you did for Row..

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

paulyeo11
Master
Master
Author

Hi Kar

Thank you for your fast reply.

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

Paul

paulyeo11
Master
Master
Author

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

Not applicable

Could u give sample file?

paulyeo11
Master
Master
Author

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

Not applicable

Hi paul,

Is you want like below image?

Capture.JPG

paulyeo11
Master
Master
Author

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.

Not applicable

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

paulyeo11
Master
Master
Author

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