most sales part by aggr

[#1]

hi all,

i want to get the most 3 part in all time and to have a pivot or line chart of each by month.

i used this expression:

sum

where do i wrong?

thnaks,

doron

(if (aggr(sum(quant),part) >= aggr( max(aggr(sum(quant),part),5),part ) , quant ))

[fernandotoledo]

use this expression as a calculated dimensin, check "Supress values when null"

=if(aggr(rank(sum(quant)),month,part)<=3,part)

this can be used either in pivot or other charts

good look

fernando

[fernandotoledo]

use this expression as a calculated dimensin, check "Supress values when null"

=if(aggr(rank(sum(quant)),month,part)<=3,part)

this can be used either in pivot or other charts

good look

fernando