In your case, duplicating data source will help.
Edit data source and crate union.
if attr([Table Name]) ="Clipboard_20170505T180336.txt" then [Referrals].[Ref Minutes] else 0 end
if [Table Name] ="Clipboard_20170505T180336.txt" then "Demand" else "Staff Capacity" end
if attr([Table Name]) ="Clipboard_20170505T180336.txt" then sum([Contact Duration]) else sum([Distinct Staff in Minutes]) end
D+C - Team_SM_10.0.twbx 301.5 KB
Thank you for the above explanation but I am new and still stuck on the first stage ' duplicating data source' I have tried to duplicate the data source but as seen in the screen below it creates a duplicated table within the sheet tab and i cannot seem to create a union.
Could it be the reason being the data source is 'live' and not an 'extract' in my file where as the sample file sent was extracted?
Shin, thanks once again but the problem I am having is.. when I do edit source on the referral table it has no UNION option but when I do edit on ICT Data source I can see UNION option - why can I not see the union option when I do it on Referral data source? Also I read in another thread I cannot locate various tables from union option in tableau version 10.0 as this feature was introduced in 10.1.
Do you mind sending me a step by step guide on file I sent in the beginning of the thread rather than your version please so I can see what exact steps were taken to copy and create a union with original data.
Do appreciate your time- thank you very much.
Below screen shows union option when I select ICT Data but no Referral data is available?
Below table shows when I select Referrals table I have no UNION option: