10 Replies Latest reply: Aug 25, 2016 8:50 AM by Sunny Talwar RSS

    how to show this expression?

    Robson Candeo

      I have to put a KPI inside a text box showing the country that has the most growth comparing actual year x prior year.

      I use this expression below in a chart straight table and it works using a dimension limits for 1 largest value.

       

      (sum({<[Year] = {'$(vCurrentYear)'}>} amount) - sum({<[Year] = {'$(vPriorYear)'}>} amount))

      /

      sum({<[Year] = {'$(vPriorYear)'}>} amount)

       

      But how to put this expression showing the Country as below without having the dimension limits for largest valeu, as this is not a chart table anymore?

       

      China - 23.42%