Displaying greater than Avg datas

[#1]

Dear Experts,

I want to draw a pie chart that just includes some values which are greater than average of Sum(Qty)

Dimensions : Product

Expressions : Sum(Qty)

I am writing : =numavg(Sum(Qty))   in "Show only Values that are" box on "Dimensions Limits Tab" but nothing..

Any idea plase

Best Regards

[lironbaram]

have a look at the attach file

i think it does what you asked for

[#3]

Dear Liron Baram,

I thank you for quick help.. When I inspect your answer it works... But i cant solve my problem...

I am attaching a sample to my message can you help me please

Best Regards

[lironbaram · Accepted solution]

hi all you had to do is change in the dimension limit last list box from 'relative to total' to 'excat amount'

attach is your file

i also change the average function to

=aggr(sum(QTY),Product) which calulte the avg the products totals

the former function calculated the avg of QTY value

[#5]

Dear Liron Baram..

I thank you

=avg(aggr(sum(QTY),Product))  is right solution and it solved my problem...

Best Regards