View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nelson Nelson is offline
external usenet poster
 
Posts: 69
Default Insert formula in a pivot table

Hi!
How can i insert a formula to count the suppliers per date?
The pivot table appears like this:

Date Supplier Total
07-07-2007 20002 4
20007 1
20020 10
07-07-2007 Total 15
08-07-2007 21025 2
20545 7
07-07-2007 Total 9

I need to put the count of suppliers per date.
So, the count of suppliers would be 3 on 07-07-2007 and 2 on 08-07-2007.
Thanks a lot!