Show query column names behind pivot table field names

I have a pivot table that I inherited. I see the SQL query that populates the data. However, some query columns have been renamed in the pivot table to get friendlier field names. e.g.

The pivot table has a field called "Fried eggs". The query returns a column called "Eggs". I suspect that the pivot table field is showing the query column with the similar name. What I need is to prove it.

So, how can I see a mapping of the column names in the source for the pivot table to the field names used in the pivot table

Not sure you can see a direct mapping of the names .. however .. if you click on the pivot table the field list should appear on the right side.

The list of fields available for the pivot table are in the column order of your data range. If the name was changed for the table, it will appear in the available fields list as the changed name, but the name in the data range, will not be changed.

Hope that helps.

yes, I can see the field names just fine. My problem is that they do not (all) match the column names returned by the query. It is easy to change the field name shown in the pivot table. Unfortunately, if you do that you cannot see what the query column is that returns the data in the now-renamed field. At least, I can't see how to do that. But that is what I need to do! I'm trying to do the field-column mapping of a pivot table in order to do some work on it.

If you look at the order in the list of available fields for the pivot table .. that is the column order in your data range.

If you have your data on sheet 2 and you have the column headers .. "Sales" .. "Months" .. "Years" .. "Bonus"

On Sheet 1 where the pivot table is the list of fields will be Sales, Months, Years, Bonus.

Now say you change the name of Months to Weeks .. Sheet 1 will list Sales, Weeks, Years, Bonus. But on Sheet 2, the column headers will still be "Sales" .. "Months" .. "Years" .. "Bonus"

That make sense? You can look at the list and see, at least, which column was changed