I'd like to now use the result of this new pivot table as the data source for a new pivot table which will further modify this data. I suppose you could call it 'nested pivot tables' In a new sheet (where you want to create a new pivot table) press the key combination (Alt D P). Display Alerts = True End Sub I guess your end goal is to show Distinct (unique) values inside your original Pivot table.In the list of data source options choose "Microsoft Excel list of database". For example you could have data set with Order Number, Order Date, Order Item, order Qty First pivot table will show you Order Date and sum of Order Qty and you probably want to see Count of unique orders in the same Pivot.We want to highlight the sales amounts that are above average.
I described a few ways to handle this in Make a Copied Chart Link to New Data.
However, one draw-back can be that you can only refresh the Pivot Tables automatically by setting it refresh on open via the Pivot Table Options.
Free Excel Help Refresh Pivot Tables Those of you that use Pivot Tables will be well aware of their power.
I have a Pivot table in excel that is using a raw table as its data source.
This pivot table is doing a bunch of grouping and summing of rows.