4 Replies Latest reply on Dec 18, 2017 11:40 PM by Shinichiro Murakami

    How to get last 3values and First 3 values from a measure

    sai lakshmi

      Hi All,


      I would like get

      i) last 3 values of a measure and

      ii) first 3 values without the help of any other columns.


      Kindly provide your suggestions or solutions to achieve this.




      To say more clearly, in the workbook I have attached there is only one column named sales which consists of 24rows.But I want to display the sum or avg of firs three values 732,262 and 732.



      Likewise I would like to get the sum of last 3 values 23,19,60.




      Have attached a twbx for that.I haven't tried since I did not have a clue on how to achieve this.


      Thanks for helping!


      Thanks & Regards

      sai lakshmi