In the data base they have more then one entry for each date but not in the
pivot table and the question here is how to put it in the pivot table, being
the data base his own source (if I use formulas in the data base, the files
gets extremely slow!).
The entry for 20002 on the 7th is the count of 4 entries in the data base.
So, what I need is to get the count of suppliers in the pivot table and
being the data base the source of that count.
I hope it's clear :-)


"Andrew" wrote:

Does each suppier only have one entry on your list for each date? ie - is
the entry for 20002 on the 7th = 4; or is it made up of four single entries?
If it's the former, then adding a Count of Supplier into your data field of
the Pivot table should return the desired result. If it's single entries
then I'd need to have another think about it!!

"Nelson" wrote:

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!