I've got my pivot table and pivot chart set up the way I want. But I'd like to show the source data in a table next to my pivot chart... not all of the source data for the pivot table, just whatever records the pivot chart/pivot table is currently showing.
Basically it's be the same as me taking my source data and applying the same filters I did on my pivot table... but every time my pivot table/pivot chart updates, I want this new table to update as well, instead of me having to do it manually.
Does that make sense?
table next to pivot chart.png
pivot table.png
Bookmarks