How to select top 3 sales person dynamicly?

[#1]

Hi,

I have a fact table as below:

Month	Custid	Sales
1	A	100
1	B	120
1	C	80
1	D	90
2	A	110
2	B	100
2	C	90
2	D	110

How to show a top 3 person in a gauge dynamicly, in stead of expression of 'sum({<Custid={'B'}>} Sales)','sum({<Custid={'A'}>} Sales)','sum({<Custid={'D'}>} Sales)' in the gauge?

[#2]

You can use a calculated dimension. Attached app has a chart with calculated dimension.

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[#4]

Thank you very much.