Question on Rank()

[mikecrengland]

Hello All -

I'm trying to create a fairly simple bar chart that ranks sales by customer. The expression is a simple sum of sales and I want the rank on the Axis.

For the Axis, I'm using

rank(Aggr(sum({<CompanyGroup = >}BilledAmount),CompanyGroup))

The expression for the bar is

sum({<CompanyGroup *= >}BilledAmount)

Which works until a company is selected I have the color set up to grey-out the unselected:

But the rank goes to 1 when a company is selected and I actually want it to keep its actual rank. I thought the {<CompanyGroup = >} would accomplish it, but no luck.

Any thoughts?

Thanks!

mike

[sunny_talwar · Accepted solution]

How about this:

Aggr(Rank(Sum({<CompanyGroup = >} BilledAmount)) * Avg(1), CompanyGroup))

[mikecrengland]

You are da man! Worked like a charm.

[vishsaggi]

Hello Sunny,

Would you mind explaining this *Avg(1) what is this used for ??

Thanks,
V.

[sunny_talwar]

Was not 100% sure if it was needed or not, but just to be safe I added it