Remove item from filter

[nbuscemi]

Hi,

Please see the attachment. I need to remove the "cost avoidance" item from the filter. Is there a way? Maybe writing some code?

Thanks, 

Noemi

[sunny_talwar]

May be this

Aggr(
    Only({1<[Expense Category] = e({1<[Expense Category] = {'COST AVOIDANCE'}>})>} [Expense Category])
, [Expense Category])

[nbuscemi]

In this way, all the items are not shown. See the attachment please. 

I just want the "cost avoidance" item not being shown.

[sunny_talwar]

What is the field called? Is it called Expense Category or is it a name you use on the front end?

[ramasaisaksoft]

write the expression in your Dim

=if(FieldName<>'Cost Avoidance',FieldName)

[nbuscemi]

The field is CATEGORY_EXPENSE.

I use "Expense Category" in the frontend.

[sunny_talwar · Accepted solution]

Then try this

Aggr(
    Only({1<CATEGORY_EXPENSE = e({1<CATEGORY_EXPENSE = {'COST AVOIDANCE'}>})>} CATEGORY_EXPENSE)
, CATEGORY_EXPENSE)

[nbuscemi]

GREAT!!! It worked! 

Thank you so much!

[RioH]

This worked - Thanks