2 Replies Latest reply on Mar 3, 2014 7:27 AM by Sheryl Tufts

    Bespoke sub totals

    Paul Collier

      Is it possible to create a bespoke sub-total to sit along side existing sub-totals?  So something like this...

       

       

      GeographyProductCustomer TypeIncome
      EnglandVacuumsNew £        75,000
      Existing £        23,000
      Total £        98,000
      CookersNew £        51,000
      Existing £        12,000
      Total £        63,000
      TVNew £        18,000
      Existing £        42,000
      Total £        60,000
      Total £     221,000
      New Total £     144,000
      Existing Total £        77,000
        • 1. Re: Bespoke sub totals
          Tracy Rodgers

          Hi Paul,

           

          You can do this by creating three calculated fields, one for New, Existing and Total. They would look similar to the following:

           

          New:

          if [Customer Type]='New' then [Income] end

           

          Existing:

          if [Customer Type]='Existing' then [Income] end

           

          Total:

          sum([New]) + sum([Existing])

           

          Then, remove Customer Type and Income from your view. Place Measure Names where Customer Type was and place Measure Values on the text shelf with only the above 3 calculations on the Measure Values Card. Finally, turn on the grand total by going to Analysis>Totals>Show Column Grand Totals.

           

          Hope this helps!

           

          -Tracy

          • 2. Re: Bespoke sub totals
            Sheryl Tufts

            Hi Tracy,

            Thanks for posting this. It works great for 1 Measure. How can this be accomplished for multiple Measures? For example add 2 columns to the right of Income in Paul's example called Cost and Profit.

            Thanks,

            Sheryl