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!
|