11 Replies Latest reply: Jul 15, 2010 2:20 AM by swatisinha17 RSS

    How to calculate subtotals in a pivot table for a particular column values?

    swatisinha17

      Hi All,

      Please refer to the attached xls file.

      I am importing data from this xls file into a pivot table. I have two columns in the excel, that is, Score and Category. I need to calculate the total score for different categories.

      For example:

      Category Score

      customers 10

      20

      5

      SubTotal: 35

      Internal Processes 20

      10

      30

      SubTotal: 60

       

      Pls. suggest how to represent data in this form in a Pivot table in QV?

      Regards,

      Swati Bansal