3 Replies Latest reply on Oct 17, 2016 12:45 AM by Shriram Saxena

    duplicating sales on every row

    james.raikes

      HI,

       

      I am having an issue with my data an wondering if you can help. I have been given a report that shows all customer X systems and there sales but the sales totals are given as a total for the account not per individual systems. The result is that if I am trying to leverage systems and total sales in a report the systems count fine but the sales show against each line as shown below.

       

       

      Account: Region

      Account Names

      System typesales
      Americasxs8
      Americasxs8
      Americasxa8
      Americasxa8
      Americasxa8
      Americasxas8
      Americasxs8
      Americasxs8
      Americasxs8
      AmericasXa8

       

       

      Is there a way using a formula that I can just show the total for an account sales once under the account but still show all the systems?

       

      Kind Regards

        • 1. Re: duplicating sales on every row
          John Croft

          I'm sure there's a away. Can you post your packaged workbook or at least a sample of spreadsheet with dummy data?

          • 2. Re: duplicating sales on every row
            John Croft

            Just quickly dragging everything to the rows shelf, this is what I see. Not sure why you would get a sum at the account level. 

             

             

            You can always fix the calculation at 'system' and receive the below:

             

             

            Here's the calc:

             

            { FIXED [System type]: SUM([Sales])}

            • 3. Re: duplicating sales on every row
              Shriram Saxena

              Hi James,

               

              As far as I have understood your problem,

              You want to visualize the aggregate value of sales value Account Name wise and what is the aggregate sales value for the various System types that are contributing for the particular account name.

              I have created a sample data for you and a dashboard associated with that data.

              In the dashboard Account name wise sales is shown and if you click on any particular account type you will get a drill down for what are the system types are there in a particular account name.

               

               

              PFA: Data , Dashboard

               

              Dashboard: Please click on any Account Name to see the drill down for systems.

               

              Is this what you are looking for??

               

              Best

              Shriram Saxena