4 Replies Latest reply: Sep 26, 2016 5:47 PM by Sunny Talwar RSS

    Question on Rank()

    Michael Reagan

      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?