Excel 2010 Pivot Table Calculated Field Between Max of Dates Attended Field and Start Date Field

[PWD]

Good afternoon, is it possible to create a calculated field in a Pivot Table from a column that is using a MAX value of a date?

Basically we have data for people who have attended on more than one occasion and I have a pivot field that shows the MAX of all their attended dates. We also have the date when they started. What I want to do is calculate the difference in days.

Additionally it would put a cherry on top if I could calculate the date diffrence between now and when they started if they have nothing in their completed field.

Any help would be gratefully received.

Many thanks,
D€$

 

[SkipVought]

Hi,

Where is the source data for your PT?

 

[PWD]

Hi Skip, on another worksheet.

Many thanks,
D€$

 

[SkipVought]

Is it not possible to perform such calculations in that source table?

You might even use a query, rather than a PT.

Don't be a craftsman that thinks a hammer is the tool for every task!

 

[PWD]

Hmm, I was wondering along the same lines. I'll give it a go on Monday. Thanks.

Have a nice weekend.

Many thanks,
D€$

 

[PWD]

I had all the unique record identifiers sorted in column "C", with the episode start date in column D and each activity date in column I. Some of the unique records have started more than one episode and some have a episode closed date, but not all of them. This did for a start:-

=IF(C2<>C3,I2-D2,"")

Many thanks,
D€$