Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Pivot table it is possible to have total amount display on the Top Row ?

Hi All

I have a pivit table . which display all Diff type of Exp . which provide individual  items expense amount. with out a total .

I like to have have a total sum on Top row.

May i know how to do it ?

Paul

1 Solution

Accepted Solutions
Anonymous
Not applicable

Paul,

Now I can open you file, and see what the problem is.  I thought you wanted to move totals from bottom to top, but in fact you couldn't get totals at all.

To fix, go to the tab "Style", and uncheck "indent mode".  After this, you can use "show partial sums" (Presentation tab).  Now you can check the intend mode agin, if you need it.

Regards,

Michael

View solution in original post

6 Replies
paulyeo11
Master
Master
Author

Hi All

Enclosed my QV Doc

Anonymous
Not applicable

Hi Paul,

I cannot open your application for some reason.  anyway, there are radio-buttons "subtotals" on the properties Presentation tab, whre you can choose "subtotals on top".

Regards,

Michael

paulyeo11
Master
Master
Author

Michael

Thank you for reply my post

Yes usually your approach will work , i already try but fail.

Not sure any reasons. Can some one help ?

Paul

Anonymous
Not applicable

Paul,

Now I can open you file, and see what the problem is.  I thought you wanted to move totals from bottom to top, but in fact you couldn't get totals at all.

To fix, go to the tab "Style", and uncheck "indent mode".  After this, you can use "show partial sums" (Presentation tab).  Now you can check the intend mode agin, if you need it.

Regards,

Michael

paulyeo11
Master
Master
Author

Thank michael

Not applicable

Hi Michael,

I wanted to have sum of the Quarter filed (Which I used as dimension). Follwed ur steps as u mentioned here and it worked as expected. But the problem is for the Total Column(Partial Sum), am getting the font color of the field as well as the values in Bold and the background for this column in Grey.

I want the field values to be displayed in regular color and the background should be white.

Please advise.

Thanks & Regards,

Ashish