View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
adodson adodson is offline
external usenet poster
 
Posts: 13
Default Pivot Table Data Sum/Count

Ok, please forget the above message. I figured that out. My real question
is, is there a way to use the ceiling/floor functions on the totals in a
pivot table?

For example, I often use the formula: Ceiling(Floor(number, 1),5)
However, I don't see where to enter a formula such as this when using the
pivot table.

Again, assistance is appreciated. Thanks!