Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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