Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Resolved · Low Priority · Version 2007
Lynne has attended:
Excel Advanced course
can you change the grand total column so that it takes the difference between 2 of the data columns e.g. to see year on year improvement
Hi Lynne, thanks for your query. You can't change the nature of the grand total column because that is wired into the pivot table tool itself. However, you could create a custom calculated field which would perform a difference calculation and which you could then add to the pivot table in place of the grand total column.
Hope this helps,
Anthony
|
|
Excel tip:Some examples of CTRL key shortcuts in Excel 2010Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version? |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.09 secs.
