5 Replies Latest reply on Jul 9, 2018 11:26 AM by Anuvir Singh

    YOY Actual Values with an added dimension by month

    Eric Brown

      I would like to create a calculation to get the actual of the previous year's (same month) value.  For instance, using the Tableau sales sample as shown below, the "Consumer" segment would have a value of $6,928 for January 2015.

       

      I've tried this fixed calculation with no success:  {FIXED [Segment]: SUM({FIXED MONTH([Order Date]), YEAR([Order Date])=2014 : SUM([Sales])})}