Excluding a filter from a particular chart

[Anonymous]

Hi,

I am creating a sheet where I have two charts, I want to apply all filters on one chart but all except one on the other.  could you please help me with the best way to do it? I tried using set analysis, something like -

=Sum({<[Reporting Customer]=>}[Gross Sales])  This works well for such cases, but does not work for chart where I do not have an aggregation such as in a histogram, or in cases where I use a calculated field such as % contribution where I basically do sum(sales for a particular customer)/sum (Net sales).

Is there a better way than using set analysis, I tried alternate state, but that wont allow me to apply all except one, I am only able to assign one state to one chart.

Any suggestions are much appreciated!

[OmarBenSalem]

maybe in ur second chart, just add the filter you don't want to affect ur chart:

sum({<yourFilter>}yourMeasure)

[isingh30]

Please share your data.

Thank you!

[Anonymous]

Hi, Yes that works, but this does not work when I do not use an aggregation. For example in histograms, =[Net Sales per kg], how do I alter this to exclude the filter, Customer? Could you please suggest?

[OmarBenSalem]

And why exactly don't you use aggregation in your expressions?

What's the point?

[mukesh19]

Create the variables in the separate table then you can achieve

[Anonymous]

Basically I want to understand how to exclude a filter in a histogram, here in this case. The histogram only asks for one measure, which is sales in my case. I want to see the frequency based on the sales value.I am not able to figure out where exactly is the expression for y axis which uses count. The default expression for x axis was ser to =net sales which does not use an aggregation.

[Anonymous]

Could you please elaborate a bit?

[sunny_talwar]

I think Histogram chart doesn't have any expressions... it is created using a field name... that might be what the concern is

[Anonymous]

Correct, it only asks to create it based on one dimension. The default expression that was auto created here was =netsales as I selected net sales as the dimension. I am not able to locate the expression for count and here I cannot apply set analysis as it does not have an aggregation.