Hello,
I've attached a photo of my current joints. It's 3 Excel files that I combined into 1 file and joined each sheets in tableau. By doing so, I thought it'd be easier to combine my "Teams" field but it isnt that easy. There are different line items associated with this field so if I combine them in tableau, my data gets messy. These team names are mostly the same in each sheet.
I need to pull the grand totals of each sheet in a brand new sheet and for each team. Currently, i can display the monthly grand totals in each one of the 3 sheets, per team, with my scaffold date but I need that monthly total for each individual team together, in a separate sheet
What’s the best way to get all those grand totals out of all 3 sheets in a brand new sheet but for individual teams? I have a total of 15 teams.
Hi @alex t -
Like @Peter Fakan , if you spend bit time to simplify the data source, everything will come to place much easier.
- I created a new data source UNION and since you have date fields on each of the table, you don't have to do the full cartesian. You can join it by date.
- With UNION, Tableau will automatically add a new dimension Table Name that you can use for the report.
Let Peter and I know should you have any question. If the solution helps, do mark it as best. The sample solution is attached.
