1 Reply Latest reply on May 2, 2016 6:16 AM by Yuriy Fal

    how do i remove a row from the subtotal row sum without filtering out?

    Ryan Barham

      for example i want to filter out Orange from the subtotal row but i still want it show on the worksheet

       

      FruitsHeader 2
      Apples1
      Orange3
      Banana2
      Total3
        • 1. Re: how do i remove a row from the subtotal row sum without filtering out?
          Yuriy Fal

          Hi Ryan,

           

          So you would like to exclude Orange value

          from summing up Total of Header2 Measure?

           

          It could be done by using a custom total calc like this:

           

          // Header2 Modified Calc

           

          IF MIN([Fruits]) = MAX([Fruits])            // this condition defines a Total cell

          THEN SUM(

          if [Fruits] != 'Orange' then [Header2] END // this is a filter inside of an aggregate

          )

          ELSE SUM([Header2])                         // this is for the rest of your table

          END

           

          Hope it could help

           

          Yours,

          Yuri