View Single Post
  #5   Report Post  
Matt D Francis
 
Posts: n/a
Default Hide 0% figures in Pivot Table

Makes sense but how can I do that? The % figure I see is being calcuated by
the Pivot from a count of values in a column on a separate worksheet, I can't
view the formual it uses.

"topola" wrote:

I would than just use =Round(X,2) for you row data just producing real
zeros for this purpose. TP