In the attached file, I have a formula that calculates a pct of weight loss for each team member.
I would like to build a pivot table that does the same calculation for the summary rows instead of summing the percentages.
Is that possible?
I am using Excel 365.
Thank you for your help.
Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks
Add a calculated item to the table.
Example file includes screen shot of dialog.
Thank you! This worked perfectly! Much easier than I imagined it would be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks