Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
This is my expression in straight table:
=Only({<[Product Code] = P({$} [Product Code] )>*State_1<[Product Category]={'Sports'}>} [Product Group]
How to convert the same as dimension instead of expression?
Thanks in Advance.
Try this in your calculated dimension:
= Aggr(Only({<[Product Code] = P({$} [Product Code] )>*State_1<[Product Category]={'Sports'}>} [Product Group]),[Product Group])
Try this in your calculated dimension:
= Aggr(Only({<[Product Code] = P({$} [Product Code] )>*State_1<[Product Category]={'Sports'}>} [Product Group]),[Product Group])
Hi Vishwarath,
Thanks, its working.