Converting Expression value to Dimension in Straight table

[mkiran_18]

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.

[vishsaggi · Accepted solution]

Try this in your calculated dimension:

= Aggr(Only({<[Product Code] = P({$} [Product Code] )>*State_1<[Product Category]={'Sports'}>} [Product Group]),[Product Group])

[mkiran_18]

Hi Vishwarath,

Thanks, its working.