Pivot table object

[#1]

hi,

i have a pivot table like below.

Group	Count	UniqueCount
Team1	3	3
Team2	18
Team3	26	26

for measure column "Count" - i am using the formula "count(members)".

for measure column UniqueCount - i want to get the normal count(members), but under Team2, it should not count the members that already have been counted in team 1 and Team3.

Under Team2, we have few members from team 1 and Team 2, and i want to exclude them in my count.

is it possible?

thanks

Prasanta

[MK_QSL]

I can't guess what your application is having.. I can only work based on the data you have provided.

[#3]

yeah, thanks for your help,

for a sample, i just mentioned three group.

but in my real data, i have around 20 groupname.

[MK_QSL]

If you think that your problem (according to mentioned in question and according to data provided) is solved, kindly close the thread by selecting appropriate answer..