Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have Bar chart, currently we are showing Top 10 Managers values. Need to calculate Top 10 Bar value totals only not for all the Bars. We are getting Totals for all the Bars, Can you help me to write the expression to get Top 10 Total.
Thanks.
Can you provide any sample data?
If you want to display the Total for Top 10 values in your chart in a text object or in Chart title then you may write something like below.
Assuming that your dimension is "Manager" and your measure is "[Sales Volume]"
=sum({< [Manager] = {"=Rank(sum([Sales Volume]))<=10"} >} [Sales Volume])