17 Replies Latest reply: Dec 3, 2013 12:24 PM by Joel Ferringer RSS

    FirstSortedValue in Line Chart

      HI.

      I'm trying to use this function to retrieve the firstsortedvalue of revenue expression, in a line chart, with Date and Customer dimensions.

      Basically, I want the value to be the first one shown in the chart with respect to the other parameters chosen.

      The overall idea here is to divide each month's revenue by the first sorted value's revenue, to achieve % change.

      But I can't get the firstsortedvalue to work properly.

       

      Here is my syntax, which clearly has problems because it does not retrieve any data.

       

      =$(vPremiumRevenue) / FirstSortedValue($(vPremiumRevenue), [MonthYear], [Customer Name])

       

      Any idea what I'm doing wrong here?

       

      Thanks!