The Power Query seems to work great even when updating and refreshing the data.
The pivot tables explode when trying to refresh them and only show the totals after refresh.
So question is how do I copy the power query or create these power queries in the actual spreadsheet please?
just re-create PT, add filter CodC, DCscription to existing Qty and it will work
all steps you can see: Data tab, Show Queries, in Workbook Queries you will see four tables , right click on any table and Edit then you'll see steps
all these tables are copied from the first but differently filtered
Sandy666, Thank you I was able to figure it out and got them created in my actual spreadsheet. This solution seems to work very well for what I need. I think I prefer it not to automatically update because i think it slows down the spreadsheet in general. I think i will be ok manually refreshing the tables.