4 Replies Latest reply on Sep 29, 2016 7:13 AM by Samuel Gee

    Can I have relative and overlapping date segments?

    Samuel Gee

      I would like a dimension of which the values are:


      Last Week

      Last Month

      2 Months ago

      3 Months ago (or similar)


      Where each value is the sum of sales from the beginning of the database up until that point.


      Assuming today is the 8/4/16 (d/m/y) and the DB started 3 months ago:


      Dimension Value/Table Header -->
      3 months ago
      2 months ago
      Last Month
      Last Week
      Effective Date1/1/161/2/161/3/161/4/16
      Sales in DB101555
      VALUES SHOW IN VIZ10253035



      These can't be done by an IF statement as I want everything in the 3 months ago column to also be including in the 2 months ago, last month and last week columns, and the IF will segment it out.


      Can anyone assist?


      Many thanks,