I'm trying to combine results from the <Kept> tab and the <Set> tab onto one view for each person, and add the calculation (kept)/(kept+set). I want the results to look like the tab <Kept/Set> tab. That <Kept/Set> tab is only for demo purposes and the data is not correct, hence the reason why I created two separate <Kept> and <Set> tabs. I also need the titles, "Kept", "Set" and "%Kept" at the top of the columns for the new tab.
Any ideas how this can be done?
Have you tried the Tableau 10 beta? I'm thinking you might be able to do this by using cross data joins.