Hi All,

I'm having quite a difficult problem showing "changes in data" within one pivot table.

In my spreadsheet have data of a "Status" & "Stage" value at a certain point in time. I then have the New status & stage upto to date.

I can create two pivots to show the differences, but how would I place them both in the same pivot table to show the changes?

i.e. Was Active, now Inactive and then a count.

Any thoughts would be appreciated.

Thanks.