removing the certain values

[prabhas277]

Hi All,

i am having one chart now my question is i want to delete the certain values from the legend.

For example i am having some values on the X-axis like 1,2,3,4,5,6. But  i dont want the value 1

How to delete that value or hide?

[Anil_Babu_Samineni]

You can write something like this

If(Not WildMatch(FieldName,1), FieldName)

Suppress from dimension level

OR use set analysis

Sum({<FieldName -= {1}>} Measure)