7 Replies Latest reply: Aug 11, 2016 10:50 AM by Robert Fishel RSS

    Totals Row with Specific Values

    Robert Fishel

      Hello.  I am wondering if there is a way to create a separate totals row in addition to the grand totals row in a pivot table.  For example, if I have the table below, here is what I am trying to do:

       

      M&M's

       

      Red         6

      Green     4

      Blue        2

      Yellow    5

      ===========

      Red and Blue subtotal   8

      Grand Total  17

       

      How do I create the conditional subtotal?  Thank you