Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I looking for a best idea to show more than 100 top values in straight chart (maybe slider or an input field with variable)
check posted sample file ....
Use this as your dimension
=aggr(if(rank(sum([SPR CSN]))<=100,Nazwa),Nazwa)
....or a quick macro exporting first N rows from this chart to excell....
In QV 11 you can use dimension limits.
You can use expression or variable.
i've got QV10
Use this as your dimension
=aggr(if(rank(sum([SPR CSN]))<=100,Nazwa),Nazwa)
perfetto mi amigo:P