5 Replies Latest reply: Oct 31, 2014 4:06 AM by Anand Chouhan RSS

    Sales Growth

    Stephen Edberk

      How to find the sales Growth in percentage?the below image is sample one.sales Growth.png

        • Re: Sales Growth
          Anand Chouhan

          You can use your formula with the metrics that you have or in which dimention you calcualte the sales growth like Year, Month, Quarter according to that use the formula

           

          Ex:-


          ( sum([MT Value]) - (sum(Previos Quarter value [MT Value])))

          /

          sum(TOTAL  [MT Value])


          In this formula it is sales growth for Quarter only.


          Regards

          Anand

            • Re: Sales Growth
              Stephen Edberk

              [MT Value]  - means Which one?

                • Re: Sales Growth
                  Anand Chouhan

                  This is example you can use your metrics

                   

                  Ex:-

                  ( sum([Your MetricValue]) - (sum(Previos Quarter value [Your MetricValue])))

                  /

                  sum(TOTAL  [Your MetricValue])


                  Regards

                  Anand


                    • Re: Sales Growth
                      Stephen Edberk

                      [Previos Quarter value] have indicate error.Which one is [Previos Quarter value]

                        • Re: Sales Growth
                          Anand Chouhan

                          Hi Stefen,

                           

                          Basic growth formula for sales growth is below expression but it depends on which dimension you use this expression like Year, Month and Quarter.

                           

                          Suppose you want to calculate growth for current year versus previous year then

                           

                          1. Fetch the current year sales value set some variables

                           

                          vYTD = Year = {$(=Max(Year))}

                          This will calculated by expression Sum({$<$(vSetYTD)> } [Sales Value])

                           

                          2. Then create variable for the previous year Sum({$<$(vSetLYYTD)> } [Sales Value])

                           

                          3. Then after all this use both expression in the gauge chart like

                           

                          Ex:-

                          (Sum({$<$(vSetYTD)> } [Sales Value])

                            /

                          Sum({$<$(vSetLYYTD)> } [Sales Value]))

                            - 1

                           

                          Note:- You have to use Metrics it is example i assume and fields and variables are different in your app also

                           

                          Regards

                          Anand