I am fairly new to pivot tables and I have a spreadsheet where the user will enter an X in the data entery spreadsheet. The pivot table counts the total X and I am having trouble summing these counts to a total on the row. The calculated fields of Sum of Total Submitted should be something like (sumD5:N5) and Total Action Taken (sum E5:N5).
I have tried changing the value field settings and tried several different options for the formula.
Can anyone help me understand what I am missing?
Last edited by janaj; 01-26-2010 at 02:01 PM. Reason: Thanks for the quick reply. That seemed to work!
Maybe you can add 2 columns to the main data to do those calculations on a per row basis.. then summarize into the pivot table and then have a formula in pivot table only for the division...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks