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

[#1]

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

[#2]

Hi Swati,

After posted two replies to your query.

Probably you have not seen it.

You have to use Sum(Score) instead of Score in expression.

It will work.

[#3]

Hi Ravi,

Thanks for your reply. It is working now, after using sum(Score) in the Expression and using Partial Sums in the "Presentation" tab for the "Type" column.

Thanks again.

Regards,

Swati