Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have PC_code and RM_Name in dimension as two different dimensions.
and i have expressions based on it in the straight table chart.
I have both as filters also.
so when i click more on PC code or Rm name it should not change.
i tried = Only({<RM_Name=,PC_Code=>} PC_Code)
but showed error
what is your requirement?
In a dimension, you want a dimensional construct, not a scalar.
Try with the aggr() function:
=Aggr( Only({<RM_Name=,PC_Code=>} PC_Code), PC_Code)
Add in your expression:
{$ <RM_Name=,PC_Code=>}
let me know