Forum Discussion
Report builder - hide values by category name
Hi everyone,
I have a table with different statistics for the previous day, where the different categories are presented as sum, avg, max and mean. For some categories the sum does not make sense, e.g. sum of the pressure during a day. So I want to hide some of the categories.
The issue is I am only able to hide one category by hiding by expression. I am clicking the relevant column, then I go to Visibility in the right pane, and choose Hidden by Expression.
=Fields!DimWell2_Level_1.Value = "Category name"
It works, but I want to do several names, but cannot find a way to do it. I have tried different Or/And, without success. Anyone got a clue?
Best regards,
Ole
I would expect Or to work like this:
=(Fields!DimWell2_Level_1.Value = "Category name 1") Or (Fields!DimWell2_Level_1.Value = "Category name 2") Or (Fields!DimWell2_Level_1.Value = "Category name 3")
2 Replies
I would expect Or to work like this:
=(Fields!DimWell2_Level_1.Value = "Category name 1") Or (Fields!DimWell2_Level_1.Value = "Category name 2") Or (Fields!DimWell2_Level_1.Value = "Category name 3")That worked! I was missing the ().
Thanks alot!
Ole
