Hello All,

I have a large set of data (over 1.5m rows) that has been aggregated, this data has been aggregated into around 20 tables and then unioned back together into a single table so we can use excel.

The Aggregated tables are denoted by a field [Data_Tab]

For this example to keep it simple we will call the entry into [data tab] D1 and D2

The way we use this in excel is to pivot and filter on D1 and use that data with a manual join to D2 using a formula, once the results are compiled we use a stacked barchart so show the data, However I am unable to replicate the join within tableau successfully.

When creating an join on a unique field, this exponentially increases the number of entry (basically a bad join) as there is, intended duplication within the table.

I am only using 3 fields from the data, One is [name], [number a] and [number b] (not real names naturally but for simplicity).

Bringing the data in twice, Filtering both data sets appropriately on [data_tab] and linking using [name] from D1, [Number A] from D1 and [number b] from D2. Brings the correct data when viewed in a table, However I wish to view these as a stacked bar chart and Tableau splits them based on D1 and D2

I understand this as Tableau dosnt really understand there is a relationship between [name] in D1 and [name] in D2, As stated above, when using this as a join it causes data errors.

Is there any solution to this?

Please note I have no really access to the none aggregated data

Thanks