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?

[salonicdk28]

Try this in your dimension

=Aggr(Only({<Product-={'X'}>}Product),Value)

It would be great if you would provide actual dimensions and how you want to see them

[aditi_haldule]

Hi, Actually there are some type of fibres/cables (dimensions)on X axis out of which I dont want to show one of them(with the name 'NC') in the bar chart. These wire types come under the column name 'Product'. Y axis shows the number of sales which is the measure. So what exactly should be put into fx of the dimension to not include this 'NC' which comes under column 'Product' in my bar chart?

[salonicdk28]

Use this as dimension 

Aggr(Only({<Product-={'NC'}>}Product),Sales)

[aditi_haldule]

This is giving me the exact total of the sales of the cables except for the NC but it shows only 1 bar in the bar chart. (So only 1 bar chart that represents total sales except NC sales) .I actually want to show all the remaining bars except for the NC channel bar on the X axis.

[salonicdk28]

Can you share me the screenshot of your expression once 

[aditi_haldule]

here product target conversion  column refers to products.

[aditi_haldule]

this is giving me 1 bar chart that's showing 67 sales which is the total sales of remaining products/channels except for the NC

[NitinK7]

may be you enter extra space before NC   -  ' NC'

[salonicdk28 · Accepted solution]

you need to write your expression exactly same as below screenshot, with no space in "-= "and {'NC'}