answer

[#1]

i have a group column type are like abc,cba,dac,Others.when i use it as dimension and take sum of sales

in bar chart i get sum of abc,cba,dac,Others , i dont want to show Others on chart .

is it possible? if yes then how?

[#2]

Have a conditional Dimension    if(dim='Others',Null(),dim) and make sure you select "Supress when value is Null" for the dimension.

Let me know if it works.

Regards

Priya

[#3]

its not working

i m attaching qvw.

in grapth i dont want to show others.

[#4]

Please see attached.

The chart on the right is duplicated, because I have my solution (applying a setAnalysis to exclude others...) and the answer suggested by Priya Kakarla.

Both give the same values.

Does this help you?

[#5]

i am not able to open your qvw

but i have used above expression and its not working .

i m still getting others count on chart.

[#6]

Do you have the personal edition?

[erichshiino · Accepted solution]

Hi,

You can change your set analysis to exclude 'others' from your possible values in the dimension:

Sum({<[month]={$(vmonth)}, tg-={other}>}visit)

and

Sum({<[month]={$(cmonth)}, tg-={other}>}visit)

Hope it helps,

Erich

[#8]

Enrichs solution is the one I also suggested.

In addition, the first suggestion (from priya) also works: the expression in your dimension then is

=if(tg='other',null(),tg)

Make sure that this calculated dimension is the only one and that that checkbox is activated (named "suppress when value is null").

I think the SetAnalysis is the better option.