Attach a dummy workbook if you want an exact answer.
With Tableau, anything is possible.
Here is a dummy workbook with it as simple as possible.
Essentially I want to create a new field that has the values from Region but adding in a new value of 'West Region'
- West Region
West Region would be LA, SD, and SF together so when used as a filter it should reflect the Revenue correctly.
Dummydata.twbx 10.4 KB
1 of 1 people found this helpful
Here you go
A group field is created by labeling each metro territory as east or west regions.
Then this group dimension can be used as a filter.
This is a great thought but unfortunately I have other sources that I need to link to. I ended up working on fixing the data in the backend to get it to flow through properly to achieve exactly what I wanted.