I am having an issue getting my data to sort twice essentially on a pivot table. I have 2.7MM rows of data fed into power query that then load into the data model to avoid missing out on any data. That then feeds into a number of pivot tables that clean up the data and feed into pie and graph charts. I've attached a sample of what the cleaned data in the pivot tables looks like. The Retailer Dollars sort highest to lowest, but then I need the Competition dollars to sort highest to lowest AFTER the retailer company list is exhausted. next to the pivot table is how I'm wanting the end result to look. Any ideas? I've tried sorting the power query, but because it's feeding into the data model, the sort isn't holding.
Bookmarks