3 Replies Latest reply on May 16, 2018 6:49 AM by Deepak Rai

    How to Sum Sales Fixed at Specific Quarter (Should be Easy)

    Ryan F

      Hi All,

       

      I have a very simple question. All im trying to do is sum the sales for Q1 vs Q2.

      Sales is a measure (Obviously) and the date is a field with a bunch of random dates.

       

      I was thinking something as simple as

       

      For prior values

      Fixed Q1 : Sum (sales)

       

      For current Values

      Fixed Q2 ; Sum (Sales)

       

      Eventually, I want to change this to years but right now my data does not have that.