I would like to help you! However, I'm a little fuzzy on what you are looking to do. Could you post a sample of your data/workbook so we could play with the data.
I also don't know what your desired outcome is? You mentioned switching the red with the other candidate in the same district. Are you asking to sort from highest to lowest within each district?
Hi Matt, my apologizes. I forgot to include my link to the data that is posted on Tableau public.
Here is the link: Tableau Public
So, what we're seeing in the data in this visual is the opposition amount that was spent against that candidate. My goal is to not have that assigned to the candidate, but the person that spent it against them. So basically I need to swap the values that are show for each candidate within each district.
Please let me know if you have any further questions.