Help with Rank in a set analysis

[#1]

Hi all,

For the chart, i just only to display the top 2 amount for each user, and only taking the amount when indicator =S. So something like sum({<Indicator = {'S'}>}Amount ).

Thanks

J

[tresesco]

Like this?

[#3]

Thanks Tresesco,

But i want it in a bar chart. can you help? e.g. a bar chart for User A with the top 2 value added together....

[#4]

Might need a aggr here, but i'm not sure how to do a aggr within the rank

[tresesco]

May be this?

Sum({<Indicator={S}>}If(Aggr( Rank( Sum( {<Indicator={S}>} Amount)),UserName,Amount)<3,Amount))