Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
sum( {<Product=P({<Product={'A'},Type={'Regular'}>} Product)>} sales) + sum( {<Product=P({<Product={'B'},Type={'Regular','Adv'}>} Product)>} sales)
maybe:
sum( {<Product=A, Type 'Regular'>} sales)
+
sum( {<Product=B,Type 'Regular'>} sales)
+
sum( {<Product=B,Type 'Adv'>} sales)
sum( {<Product=P({<Product={'A'},Type={'Regular'}>} Product)>} sales) + sum( {<Product=P({<Product={'B'},Type={'Regular','Adv'}>} Product)>} sales)
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
sum( {<Product=A, Type='Regular'>} sales)+sum( {<Product=B,Type='Regular','Adv'>} sales)
Thanks