Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
calculated items pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculated items in Pivot table

Calculated items in Pivot table

ResolvedVersion 2003

Suniel has attended:
Excel Advanced course

Calculated items in Pivot table

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

RE: Calculated items in Pivot table

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

Please browse our web site to find out more about
microsoft excel courses in and other training courses.

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 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.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.09 secs.