Referring to the attached excel, if I want to have the "Return" column showing the sum of the PL over the sum of the MV, with reference to the "Main ID", how do I go about doing it in Tableau?
Assuming no changes to the data source. The current data source's "Return" gives the return based on the "Sub ID" instead of the "Main ID".
Thanks for any help!
Please try this,
Great, thanks Lei!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...