I have an excel workbook with two worksheets. both have the same overall structure. There is a name, dates, and then data field for each dates. The difference between the two worksheets is the data fields. How do I get tableau to choose the datafield based on the worksheet selection (using a parameter). Example below:
Sheet named "SouthEast"
Product Date Amount
Sheet Named "NorthEast"
Product Date Amount
The data set is a bit more complicated than this, but I wanted an easy example as an illustration. I would like for the amount to be based on the parameter I select, which would tell Tableau which Excel worksheet to pull from.
Seems like a simple thing but I am stuck.
You may want to look at unioning the tables together. When you do that, it will add a "Table Name" field to your data, which allows you to choose which set of data you're looking at.
