Unique Count in Pivot table

[mangeshp4]

I want unique count in pivot table, aftering surfing I have added formula in source sheet.

Problem is I am filtering the data using Page in Pivot table which gives count 0, To explore I am attaching a file please go through it & suggest.


Thanks,

[DonkeyOte]

It's not clear if you intend to use a single value in the Page Field at all times or not (ie All or one of the other options - never a combination)

If it is to be an "All" or "one item" affair then I would suggest the following:

Insert a Key Column to 'OB Master'

Please Login or Register  to view this content.

Amend your Unique Count calculation as follows

Please Login or Register  to view this content.

you will then find that as you adapt the Page Field on your Pivot so the Unique Count calculations will adapt accordingly.

edit: revised formula... you would also need to refresh the Pivot Cache when you adjust the Page Field (ie refresh or use code to automate)

[mangeshp4]

single value in the Page Field at all times will be used, hey but am getting zero as result every where where as sum of formula shub be 15.

[DonkeyOte]

Why not try amending your original sample file per the instructions in post # 2

[mangeshp4]

Thanks a ton

There is always new thing I learn & explore.. This feels great.

[lazyvba]

Hello,
For unique count in pivot table, could you try my solution?
It's just code to paste and should be adapted to nearly any pivot.
it's working as any other pivot field, so filters, row and columns fileds are taken in account.
http://lazyvba.blogspot.com/2010/11/...-to-count.html
Let me know