Yes, this can be done with some simple custom SQL to duplicate your data, one copy for each measure, eg revenue, profit, margin.
If you would like to see an example, please provide a sample packaged workbook that represents your situation.
Say no more, custom SQL. Got it, problem solved!
I definitely wish this was available as a functionality within Tableau but sql will do for now!