Set Analysis question

[rmuhammad]

Hi All

What would be the Set analysis statement to select following ? Please help

sum( {<Product A with Type 'Regular'  and  Product B with Type 'Regular' & 'Adv'>} sales)

Product	Type
A	Regular
B	Regular
B	Adv

[wdchristensen]

maybe:

sum( {<Product=A, Type 'Regular'>} sales)

+

sum( {<Product=B,Type 'Regular'>} sales)

+

sum( {<Product=B,Type 'Adv'>} sales)

[jwjackso · Accepted solution]

sum( {<Product=P({<Product={'A'},Type={'Regular'}>} Product)>} sales) + sum( {<Product=P({<Product={'B'},Type={'Regular','Adv'}>} Product)>} sales)

[adityaakshaya]

Hi Rashid,

The easy work around can be merge these two columns into one in data model and name it as producttype and you can use below expression.

Sum({<product type = {'ARegular' ,'BRegular' , 'BAdv' } >} sales)

Regards,

Akshaya

[wdchristensen]

sum( {<Product=A, Type='Regular'>} sales)+sum( {<Product=B,Type='Regular','Adv'>} sales)

[rmuhammad]

Thanks