Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try
=count({<MemberId =p( {<Category ={A}>})*p( {<Category ={B}>}) >} DISTINCT MemberId)
Try this,
Count({<MemberId = p({<Category = {"A"}>}),Category = {"B"}>}Distinct MemberId)
Regards,
Kaushik Solanki
Try
=count({<MemberId =p( {<Category ={A}>})*p( {<Category ={B}>}) >} DISTINCT MemberId)
Hi,
PFA Hope this will work for you..
Thanks
Vishal