Top 10 values to show in the Pie Chart

[#1]

Hello Friends,

How to display the top 10 values only in the Pie Chart like

Dimention as Customer and the expressions like as in the below in a cyclic Group

=Sum(Amount),.

=Count (Number of Pieces)

=Count (Lines)

Any used expamples will help me lot.

Regards

Chriss

[khadeer]

Write in calculated dimension

aggr(

if(rank(total sum(amount))<=10,Customer))

[#3]

Or if you got QV 11 installed you can under the Chart Properties go to the tab Dimension Limits and tic the box "Restrict which values are displayed using the first expression" and then choose the option Show only...

[er_mohit]

hiii

see the attached file

[#5]

hi

see the attachement

or

you can try this

if(Aggr(Rank(Sum(Amount)),customer) <= 10, Sum(Amount))

rank(sum(Amount)) calculate the rank for overall dimension..

so only it shows first ten ranking values n for others it display null..

[#6]

Hi QV Learner,

Thanks for your help, I can do this for a single expression suppose I have only amount but I have number of pieces and Lines are in my cyclic expression.

Please let me know how this possible.

Regards

Chriss