Hi,

This pivot table is used to track referrals for an employment service, and needs to show monthly totals of referrals, enrolments, cancellations and placements.

I have the referral date as one of the row lables, but it seems that each of the others now only reflectes back to that date rather than the date entered in that value

EG:

5 clients referred in September, One was placed in October, 2 in December and 1 in Jan but the totals for placed are all showing in September rather than the month the clinet was placed.

Any ideas on how to fix this?