Re: Count By Criteria & Date

dear Dave,

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... =)