98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables Calculations
Pivot Tables Calculations
Resolved · High Priority · Version 2003
Mon 16 Nov 2009, 15:53Delegate Pat said...
Pat has attended:
Access Advanced course
Pivot Tables Calculations
In a pivot table I would like to subtract the max count for the sum of total.
I can do it simply outside the pivot table however I would prefer to have the formula inside the pivot table.
The values are both columns in the 'data' section of the pivot table.
Regards,
Michael Johnson
Thu 19 Nov 2009, 11:14Trainer Stephen said...
RE: Pivot Tables Calculations
Hi Pat
Thank you for your question
Could you please clarify what you want to extract the max count from?
Thanks
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Add Text to Displayed Numbers in Excel 2010To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text! |
