I do not want to show an specific category in my graph

[Nemo1]

Hello everyone, 

I want to build a Bar Chart. 

I have many different categories, but I want to exclude one.

I go to measures, and I write the following formula: Sum({<Sales-={'XCategory'}>} Sales)

However, this keeps showing me the XCategory... what am i doing wrong?

thanks in DVANCE

[Brian_C]

Hi

You need to use the column name for the categories in the set analysis. Try the measure below but repla ce category with the name of your column.

Sum({<Category-={'XCategory'}>} Sales)

Kindest regards

Brian

[F_B]

Hi @Nemo1 ,

in your set analysis expression you should replace Sales, here highlighted in bold,

Sum({<Sales-={'XCategory'}>} Sales)

with the field where 'XCategory' belongs.

Hope it's helpful, have a nice day.

[F_B]

I've just seen that @Brian_C already gave the same answer.