Pivot Table Details

Hi All,

I have just been passed a spreadsheet from an ex employee and been asked to work out where the pivot table is pulling the infomation from.

Can anyone point me in the right direction to work out where to look?

I have tried clicking on the field but that just brings out the field details.

My problem is that we have changes our tiering and every one in level 2 must now be classed as an associate and not a partner. However, I have no idea where the "Tier" box is pulling the data from.

Thanks in advance all!!!

Jon