Top and Bottom Customers show together in bar chart.

[rupaliqlik]

Hi Team,

I want to show Top and bottom N customers with positive gap and negative gap. But there are around 60 customers so scroll is coming. User don't want scroll. How to to show top or bottom 10 customers together in bar chart. Also I am calculating variance by subtracting MTD ACT master item - MTD LO master item.

MTD ACT - MTD LO

Best Regards,

Rupali

[abhijitnalekar]

Hi @rupaliqlik ,

Please try below setanalysis.

Please try below set analysis.

=if(
aggr(rank(-Sum(measure)), Diemsion) < 10
or
aggr(rank(Sum(measure)),dimension) < 10
, dimension)

Hope this solve your purpose