Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Thanks alot Manish.