Team,
In the Source Report I created a Category Column and in that column I have expression as below
Case
Condition 1 then ('Primary')
Condition 2 then ('Secondary')
else ('N/A')
End
So when I publish the Cube this Dimension shows all these 3 values
Primary
Secondary
N/A
Is there a way that we can hide the N/A category and the Total should be based on Primary & Secondary.
Please suggest on this!
Thank you!
Kiran