3 Replies Latest reply on Dec 12, 2018 9:17 AM by Naman shah

    Grand Total Issue

    Naman Shah

      Hi

       

      Here is my Requirement I have to display Grand Total row but with this requirement

       

      Sales, Goals and LY Sales are fine. But for % to LY  and % to Goal it is displaying total of of rows but I want

      to display %to Goal total should be Grandtotal of Sales / Grand Total of Monthly Goals

      same for  %to Ly  = Grand total of Sales / Grand total of LY

       

      Is it possible ?

       

      Thanks

      Naman

        • 1. Re: Grand Total Issue
          Michael Ye

          Naman,

           

          You need to use LOD expressions.

           

          Try: % to LY

           

           

          SUM({FIXED [Month_of_]:SUM([Sales])}) / SUM({FIXED [Month_of_]:SUM([LY Sales])})

           

           

          % to goal:

           

           

          SUM({FIXED [Month_of_]:SUM([Sales])}) / SUM({FIXED [Month_of_]:SUM([Goals])})

           

           

          [Month_of_] is the dimension you used. It is not complete here, since in your screenshot it only show this.

           

           

          Hope it helps.

           

          Michael Ye

          1 of 1 people found this helpful
          • 2. Re: Grand Total Issue
            maneesh.gaddam

            Naman,

             

            You should aggregate the Metrics and then apply the division for the grand total you're expecting.

             

            So, if you have your % to LY  as [Sales]/[LY Sales], it sshould be SUM([Sales])/SUM([LY Sales])

            and same thing with % to Goal it should be SUM([Sales])/SUM([Monthly Goals])

            • 3. Re: Grand Total Issue
              Naman shah

              If I have something like this then your equation is not working

               

               

              Equation i wrote for % to MTD

               

              SUM({FIXED [U_Division]:SUM([MTD])})/SUM({FIXED [U_Division]:SUM([Monthly Goal])})

               

              Please guide me