Set Analysis

[sagarwal16]

Hi All,

I have a query

i have to show sum(Profit )..

There are certain conditions i have to put in set analysis:

ProductCat                 CategoryName

A                                       Bb

B                                       Aa

C                                       Dd

D                                       Ee

if i select data for productCat then it should show the data for Bb, for B --> Dd,Ee,

C->all data ,D-->only Aa

how can i write the expression in set analysis for this situation to calculate sum of profit.

Thanks in Advance

[sidhiq91]

@sagarwal16  is there any logic on why you would like to pick data in this manner? We can get this done anyway. But wanted to know if there is any specific reason behind it?

[sagarwal16]

user want to be like this.. i cant do anything:(

[sidhiq91 · Accepted solution]

@sagarwal16  I was thinking something like a below expression. Let me know if it helped you.

if((isnull(GetCurrentSelections()) or GetFieldSelections(ProductCat)='C'),
Sum(Profit),
if(GetFieldSelections(ProductCat)='A', sum({<CategoryName={'Bb'}>}Profit),
if(GetFieldSelections(ProductCat)='B', sum({<CategoryName={'Dd','Ee'}>}Profit),
if(GetFieldSelections(ProductCat)='D', sum({<CategoryName={'Aa'}>}Profit),
))))