identity issue

[Look, More, What]

There's three roles. Anyone can assume any of these three roles. Each role has a seperate column.

There's a fourth column attributed to price.

What I've done is create a pivot table, so when we can see the prices if someone assumed the first role, but only one role. So we can switch roles around the pivot table, but it's only one role at a time.

Is there an easy way to create a table that shows the same person, but his or her accumulated prices depending on each role?

Because I've made a tab for each of the three roles, but as not everyone assumes each role, it's not as easy to compare side by side.

[hectop]

You'll likely have to post a sample sheet.
I'm thinking you could complete that using a report filter on the pivot and selecting multiple values

[Look, More, What]

Edited my first post to include attachment.

The problem with constantly changing the pivot table is... Well. I want to match and tie in each person to their roles, but not every filter will match up.

[hectop]

I've never do it but it sounds like you need to create a pivot from multiple tabs. If you want true pivot table functionality, you 'll have to do that.
Here's what Office support has on it. There's like other resources on the net.
https://support.office.com/en-au/art...1-e9fc8adeeeb5

If you want a static table then it could be done with a macro that would create the output.