Pivot Table Grand Total Percentages for 0.00% cell will remain empty

[srehman]

As you can see in attached snapshot before calculating Grand Total % lot of empty cell means no data which is good.
Now after calculating Grand total Percentage all empty cell becomes 0.00%.
I want to to leave it empty means 0.00%, otherwise it looks messy better to be empty.
Question is that how we can do it by using Pivot table.

 

[arthurbr]

Perhaps Pivot Table Options - Layout and Format Tab Check " For empty cells show" and leave blank ?

 

[alansidman]

xpost

Pivot Table Grand Total Percentages 0.00% cell will remain empty

As you can see in attached snapshot before calculating Grand Total % lot of empty cell means no data which is good. Now after calculating Grand total Percentage all empty cell becomes 0.00%. I want to to leave it empty means 0.00%, otherwise it looks messy better to be empty. Question is that...

chandoo.org

 

[Fluff]

@srehman
While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[srehman]

Understood in future i will avoid same post on 2 forums i have no idea these forums are linked. i was done that for a better solution.
Apologies for inconvenience