2 Replies Latest reply: Nov 7, 2018 8:53 PM by Jahanzeb Hashmi RSS

    Maybe it's simple but I need help

    Jahanzeb Hashmi

      I have a table like this

       

      idyearqtyrate
      120155200
      2201510300
      3201815400
      4201820500

       

      and I want to display Value in KPI for the year 2018

      which would be 16000

       

       

      15*400 = 6000

      20*500= 10000

      total 16000

       

      problem is I don't want to select a year and don't want to add a calculated field

       

      Thanks