1 Reply Latest reply on Jun 22, 2016 6:01 AM by Vincent Baumel

    QoQ Sales

    AS K

      Hi,

      I have a date field and Sales.I want to show Quarter over Quarter Varience based on the below formula.

       

      (Curent Year Qtr # Sales/Prior Year Qtr#  Sales) - 1

       

       

      2016

       

      2015

      Q1

      Q2

      Q3

      Q4

       

      Q1

      Q2

      Q3

      Q4

       

       

       

       

       

       

       

       

       

       

      Total Sales Growth %

      Sales Revenue

      11.0%

      12.4%

      4.7%

      (0.6%)

      8.4%

       

      12.3%

      8.7%

      6.1%7.5%

       

      Formula:

       

      (Curent Year Qtr # Sales/Prior Year Qtr#  Sales) - 1, expressed as a %

       

      Ex:  If it is 2016 Q1:

       

      (2016 Q1 Sales/2015 Q1 Sales)-1

      ..................................................

      ..................................................

      ..................................................

       

      Any one help me on this..and please post .twbx file.

       

      Thanks,

      KS

        • 1. Re: QoQ Sales
          Vincent Baumel

          What do your dimensions/measures look like? I think the answer might be a type of Level of Detail calculation, but I'd need to know a little more about your data structure. LOD allows you to specify a certain aggregation at which you perform a calculation, so we need to know what levels are possible.