7 Replies Latest reply: Sep 21, 2015 11:04 AM by Kumar Ramanujam RSS

    Calculated Rows in a Pivot Table

      Hello QV Community;

       

      Need some help, appreciate your feedback.

       

      In attached sample table(just a sample table, in actual there are millions of records)I have a pivot table that looks likes this:
      Current Table

      currenttable.gif

      but would like to have a modified table as below (by adding Gross Margin & Operating Margin rows):

      modifiedtable.gif