Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi All
Enclosed my QV Doc
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
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
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
Thank michael
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