calculation of rank in Bar Chart

[Anonymous]

Hello Expert,

Can some body help me to get rank in bar chart?

I have used this expression in Straight Table:

=num(rank(TOTAL  [Pre Tax Value (Max Year)],4,1))

But same not working in bar chart, even I have tried

=num(rank(TOTAL  [Pre Tax Value (Max Year)])) but did not work.

Please suggest how to calculate Rank in bar chart??

Regards,

Balraj

[jonathandienst]

Hi

Rank is not an aggregation function, so you would need something like Sum or Avg

=Num(Rank(Sum([Pre Tax Value (Max Year)]), 4, 1))

HTH

Jonathan

[Anonymous]

Okay,

But in straight table it was working fine, why?

With your expression, got it in bar chart.

Thanks.