Re: Count By Criteria & Date
I have created an pivot table in the sorted worksheet and repost an attached, kindly refer.
I agree with you with the date settings. I have changed it to year instead.
Now the thing is... I have created a pivot table. The pivot table only counts the number of entries but does not gives me a count distinct value only.
If you compare the result given by pivot table with what the ideal structure,
in the year 2005, Marketing dept made 6 purchase entries (2 x entertainment, 2 x food, 2 x repair = 6), that's correct.
But what i am looking at is the number of different categories they have commited the purchase categories, which is only 3 ( entertainment, food, repair ).
Hope this gives you a better picture of my problem.
Thanks alot... =)