Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
I've just seen that @Brian_C already gave the same answer.