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:

       

      Capture.PNG

       

      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