Dynamically choose field

Hello, I am trying to display data based on a users data. For example, this is what I have so far.


I have the data for each state, but want to choose the the field dynamically rather than selection a specific state. Is there any way to do this?

What you have there is a “pivot table”, which is in a form that is hard to use.

The database would work better if you can unpivot the region-separated data into something like :

State      Party  Influence
Ohio       party1  1.1
Oregon     party2  9.9
Okra       party2  5.7
Okalahama  party1  3.2

Thank you! I don’t know why I couldn’t figure that out.