Top and Bottom in Bar Chart

[#1]

Hi all,

i calculated stock index rotation with this expression :

=(sum(aggr(SUM({$<DT_DATE={'>$(vMinDate)<=$(vMaxDate)'},DS_TYPE_SHIP={'3'}>} (NR_MOVED_AMOUNT_OUT+NR_CORRECTION)),DT_DATE,DS_COMMENT)) )

/

(SUM({<DT_DATE={'$(vMaxDate)'},DS_TYPE_SHIP={'3'}>} NR_STOCK_AVAILABLE)/365)

Now i want two bar chart that show me top and bottom 5 Category Product with higher and lower index rotation.

How can i do?

Thank you

Francesca

[swuehl]

Try creating a bar chart with your dimension you want to show (Category?) and then use dimension limits to limit dimension to largest / smallest 5 values.

[sinanozdemir]

Hi,

Try to put your function in:

Aggr(Rank(and your sum), NR_STOCK_AVAILABLE) <= 5 --- for top 5

Aggr(Rank(-and your sum), NR_STOCK_AVAILABLE) <= 5 -- for bottom 5

Hope that helps.

[#4]

I try but doesn't work.