Author Topic: How to Hide a Category for a Dimension  (Read 1048 times)

Offline Kiran Kandavalli

  • Community Leader
  • *****
  • Join Date: Jun 2011
  • Posts: 111
  • Forum Citizenship: +1/-0
How to Hide a Category for a Dimension
« on: 15 Jan 2021 03:37:21 pm »
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