calculated items pivot table

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Calculated items in Pivot table

resolvedResolved · High Priority · Version 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


 

Excel tip:

Calculate age or service

The 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:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips


Server loaded in 0.07 secs.