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


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