Current Selection vs. Top 1 vs Avg

[#1]

Hi,

is it possible to create a table chart where I see all of my customers, their volumne of sales vs. the top customer volumne of sales vs. the avg volumne of sales?

Customer Sales Sales Top 1 Avg Sales
1 10.000 30.000 20.000

2 20.000 30.000 20.000

3 30.000 30.000 20.000

Thanks

[#2]

Hi,

Check the attached application.

Cheers

- Sridhar

[#3]

Hi,

thanks Sridhar,

can I put in max(all aggr(Sum(Sales), Customer)) some "Set Analysis" like <{Customer=}>, so it doesn't matter what's selected?

Thanks

Regards