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
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculated items in Pivot table
Resolved · High Priority · Version 2003
Suniel has attended:
Excel Advanced course
I am trying to insert a formula into a pivot table to calculate the difference between the value of one month versus the other. The pivot table has three sets of row data and in the columns are the months. The calculated item works except it keeps calculating and returning zero value for items that are not there! Please help
Hi Suniel
Hope the solution to tha above that we came up with last week is still working OK. If not, please let me know so we can improve things
Regards
Stephen
|
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
We'll call during UK business hours
Server loaded in 0.07 secs.