Hello. I have a profitability file for 50 states. In the first column is mix (% of revenue in each state), in the second column I have revenue total for each state, in the third column I have total expense for each state, and in the final column I have the expense margin%. At the bottom, I have a sumproduct of revenue multiplied by expense margin/divided by sum of total revenue for all states to get weight expense margin. Can I create a pivot table that will allow me to run scenarios? For example, take out the ten highest ratios, or ten lowest ratios and see the impact on the the weighted average? Thanks.