I don't know if this is possible but can I show the column average (grand total) and have it NOT take into account the div/0 on a pivot? See the attached. If you can, please walk me through it. It's 2010.
Also, is it possible to add levels of sorting within the pivot?
Use following steps:
1) Right Click on pivot
2) Then click on pivot table option
3) Then click on "For error values show"
Please consider adding a * if I helped
That worked! But how do I have the grand total still show the value?
Need for clarity on second part
Excel Pivot Help.xlsx
See the new attachment. It no longer shows the Grand Total. I want it to show the Grand Total without taking the div/0 into account.
It happens because in your data you have #DIV/0 in front of "Grand Total", that's why in pivot it's reflecting as same or blank
Correct - I am asking if I can do a work-around so the grand total doesn't = div/0, but still shows the total of the other values.
Yes same can be done but for that i need a sample file where u have actually divided "2011 - 2012 Hip Procedure Growth"
Nevermind - I figured it out. I just needed to do an Iferror on the data. Thanks anyways.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks