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