6 Replies Latest reply: Feb 15, 2017 5:32 PM by Stefan Wühl RSS

    Most current salary

    akshata tare

      I have a table with Salary history. I am trying to show a line chart with salary change over time. What should be the measure if my dimension is year>Month>?  If there is no salary entry for a particular month I would like to show the last applicable salary. For instance, for E2, the salary for 2015 should be zzz as it was in 2014.

       

      EmployeeDateSalary
      E1June 2015xxx
      E1Mar 2016xxy
      E2Jan 2014zzz
      E2Jan 2016zcx