Limitations Of Dimensions

[mariamovasheli]

Hello,

I Want to limit Number of dimensions Shown on charts. but I use Growth rate as measure, and  when I go to limitations and Fixed numbers, then it Limit it with growth rate  but I want to limit with volume of sales.How It is possible to show top 5 companies with the largest volume of Sales but as measure to have Growth rate?  

[jonathandienst · Accepted solution]

Something like

Sum(Aggr(If(Rank(Sum(-Sales)) <= 5, ... growth expression ...), Company))

Insert your expression for growth and adapt as required to your environment

[mariamovasheli]

It is exactly what I wanted Thank you very much