7 Replies Latest reply: Oct 6, 2017 2:56 PM by Sunny Talwar RSS

    Add calculated measure to "Concat/If/Aggr/Rank" function

    Aurélie Potvin

      Hi experts,

       

      I have created a text box that shows my 3 best product sales increases for a given month compared to the previous month and this for a specific region.
      My calculation is the following :

      -----------------------------

      concat(

      IF(

      aggr(

      Rank(

      (Avg({$<[Region]={"A"}>}[Sales])-Avg({$<[Region]={"A"}, Month = {"$(=Date(AddMonths(Month, -1), 'MMM-yy'))"}>} [Sales]))),

      [Product])<=3,

      [Product] & chr(10)))

      -----------------------------

       

      This works fine but does not show the increase in sales.
      Any idea how I could show this calculation in here :

      [Product] & ' (' & ??? &')' & chr(10)

       

      Thanks in advance for your input!
      Cheers