How to write this set analysis

[#1]

Hi ALl,

I have one table:

MemberId, Category

1, A

1, B

2, A

2,B

3,C

I want to use one set analysis in Pivot table to show how many Customers who bought both Category A and Category B?

Can you help me out?

[kaushiknsolanki]

Try this,

     Count({<MemberId = p({<Category = {"A"}>}),Category = {"B"}>}Distinct MemberId)

Regards,

Kaushik Solanki

[swuehl · Accepted solution]

Try

=count({<MemberId =p( {<Category ={A}>})*p( {<Category ={B}>}) >} DISTINCT MemberId)

[VishalWaghole]

Hi,

PFA Hope this will work for you..

Thanks

Vishal