Excluding values in bar chart

[#1]

Hi All,

I have a bar chart where I am showing the largest 5 brands based on sales through dimension limits. I have another bar chart where I want to show sales of all the brands, but not the ones which are already there in the largest 5 brands chart.

It will be great if somebody can help me writing the expression to exclude the largest 5 brands based on sales.

Thanks.

[MK_QSL · Accepted solution]

For TOP 5

Create a Bar Chart

Dimension

Brand

Expression

SUM({<Brand = {"=Rank(SUM(Sales),4 )<= 5"}>}Sales)

FOR Brands Other Than TOP 5

Create a Bar Chart

Dimension

Brand

Expression

SUM({<Brand = {"=Rank(SUM(Sales),4 )> 5"}>}Sales)

[#3]

Thanks alot Manish.