View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Taylor
 
Posts: n/a
Default Displaying percentage in ranges in pivot table

You are probably going to have to put a helper column with you data.
Something like this:

=if(C7 < .05,"<.05",if(C7=.05,"=.05",".05")

Then include that column in your pivot table and put it in the row
section.

You might be able to finagle this into a calculated item, but excel is
pretty strict on what you can do with a calculated item.