I'm relatively new to pivot tables and would really appreciate some
help.

I have a list of sales data I am trying to analyse. I am looking to
measure the number of discrete sale days, in other words how many times
a customer visits per year. Customers only purchase once per day but
there are multiple items purchased and when using the date field with
Count function every item adds a count. Is there a way I can only count
unique days?

Thanks in advance.


--
nick_gardiner
------------------------------------------------------------------------
nick_gardiner's Profile: http://www.excelforum.com/member.php...o&userid=35094
View this thread: http://www.excelforum.com/showthread...hreadid=548525