How to filter the dimension?

[#1]

Hi All,

I have one field named 'Category' whose values are A,B and C.

Now I put it into Chart dimension, I don't want to show C in this dimension, how to filter it?

Thanks.

[#2]

Hi Isaac ,

Try like this

=if(Category='A' or Category='B',Category)

put the above condition in the dimension ...

[AbhijitBansode]

u can write the If condition as:

IF(Category<>'C',Category,null())

[#4]

Use If condition to sort this problem as stated above.

BUt if you taking it as an seperate filter you can also take a list box and use it.

[danielrozental]

You should do filters in expressions not in dimensions

sum({<Category-={'C'}>} Sales)

Will filter Category C without affecting performance as some of the suggestions here would.

[#6]

What would happen if it has multiple category's like C, D, E, F. if you put filter on expression side, you will see one row for all these filters instead of a row per filter.

[#7]

What would happen if it has multiple category's like C, D, E, F. if you put filter on expression side, you will see one row for all these filters instead of a row per filter.

[Anonymous]

I have used Count( {filter} Field) in my measure in bar chart.

The problem is that now I see empty columns in my graph which I wanted to filter out.

[VVJ]

I used the expression IF(Category<>'C',Category) and able to filter the dimension without C.

Can you please let me know the use of ,null() here IF(Category<>'C',Category,null()).