How to add set analysis for dimensions

[aditi_haldule]

Hi,

I have some products on X axis (dimension)and their values on Y axis on a bar chart. I want to show all the values on X axis and exclude one product- so that on X axis all the products are show except for 1 which I dont want to show. Is there a way I can do that? Maybe set analysis?

[aditi_haldule]

Hi, yes that was a mistake. Now I'm able to see 4 bars on X axis which dont include NC but one of them comes in gray without a label. But their total still gives me the exact value of sales except NC. I'll figure out about that one gray bar in the bar chart hopefully. Thanks a lot! 🙂

[salonicdk28]

That grey bar is of null values, if you uncheck that option from your dimension then that will also go away

If you get your answer then please accept that as solution

Thanks

[aditi_haldule]

Yes perfect! Done!

Thank you so much 🙂