5 Replies Latest reply: Aug 29, 2016 3:16 AM by Tresesco B RSS

    Sum function for the last day in week

      I want to display sales amount only for the last of any given dimensions of week,month,Quarter,Year.

      I just want to show amount end of week, not total for per week.

      For example:

      1/1 :100

      2/1 :150

      3/1: 160

      4/1: 140

      Suppose: 4/1 is the last day in week: so it displays amount = 140