• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

A Question on Sub-Totals Within Pivot Tables

S

saankiip

New Member
Hi All


Just new here but really loving the information that is available on this site and in this forum. But to my question...


In a pivot table is it possible to have sub-totals appear in some of the columns but not others?


I have 9 columns, 3 of which are percentages and the sub-totals don't make any sense for these columns as it is just adding up the various percentages. While in the other 6 columns I have dollar amounts and so the sub-totals do make sense and are needed.


Thanks for your time!


Russ
 
Hi there - this strikes me as a good question and I don't know the answer... I'm posting this to get the thread back on the forum board in case anybody wants to chime in.
 
For Percentages, you can show Subtotal as Average - it might make sense.


I am still wondering if there is a possibility to remove subtotal from some columns.
 
You must log in or register to reply here.
Back
Top