Selective Filters

[#1]

Hello,

In my current case where I have following
Business Groups

• Affluent
• Expert Individuals
• TPGS
• New Customers

Then, each group has participants within
it.. for example

Affluent : Cust ID1, Cust ID2, Cust ID3 etc

Expert Individuals : Cust ID4, Cust ID5,Cust ID6 etc

Above groups are mutually exclusive in terms of Cust ID

Objective: I am trying to compare the revenue pattern of Cust ID from one group against revenue pattern of Other Groups(TPGS/Expert Individuals/New Customers) using a straight table.

I need all yellow columns to reflect same values regardless of which Business group they belong too.

For ex:- If I select Cust ID from Expert Individuals then all yellow columns should reflect the values of that Cust ID. In my case the Cust ID

I have tried using below set statements but they don't seem to work fine:

Sum({<[Business Grp]=>}[Revenue])

or

Sum({<[Business Grp]={'Affluent', 'Expert Individuals', 'TPGS', 'New Customers'}>} [Revenue])

Thanks,

Varun