Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this:
Aggr(Rank(Sum({<CompanyGroup = >} BilledAmount)) * Avg(1), CompanyGroup))
How about this:
Aggr(Rank(Sum({<CompanyGroup = >} BilledAmount)) * Avg(1), CompanyGroup))
You are da man! Worked like a charm.
Hello Sunny,
Would you mind explaining this *Avg(1) what is this used for ??
Thanks,
V.
Was not 100% sure if it was needed or not, but just to be safe I added it