Excel - Time Difference in Pivot

[The_Burg]

Hi i'm trying to create a calculated field in a pivot table in Office 365

I have a planned start date and an actual start date. In the spreadsheet i can subtract one from the other and get a time difference once formatted in hours and minutes.

Actual Start Plan Start
26/02/19 09:57 26/02/19 09:08 =G2-F2 works perfectly.

I need this to work as a calculated field. I just can't see why it won't work. Am i being really thick?

[Prinny]

Not got all your spreadsheet to go off, but if it’s working on the sheet, why not just incorporate that column into the pivot table? Saves faffing within the pivot itself.

[The_Burg]

Prinny said:

Not got all your spreadsheet to go off, but if it’s working on the sheet, why not just incorporate that column into the pivot table? Saves faffing within the pivot itself.

The full sheet contains a macro that collects data from a report. Then pivots it off. Doing it manually slightly defeats the object. As a calculated field it would refresh with no intervention.

[weeboot]

https://www.mrexcel.com/forum/excel-questions/8650...

Try that

[paulrockliffe]

It's worth pointing out that if you're creating your Pivot using the Excel Data Model, you'll need to use MDX to create that column in the Pivot due to the way Data Model works. Not sure if you're using Power Pivot how that interacts with Data Model, it may be possible the hang a Pivot off Data Model rather than the usual Pivot cache without realising it.