2 of 2 people found this helpful
There are a variety of ways to approach this, and they all require different hacks in Tableau. I tend to think of data display as a complicated Venn diagram of exploratory data visualization, dashboards, traditional text table/crosstab reporting, network graphs, simple charts, etc. Tableau comes out of exploratory data visualization and is oriented towards screen display, so although it can cover many of the other areas it's not necessarily able to do an exact duplicate of what another product can do.
You've talked about having one column with the values and another column identifying the measure, that's how I'd first approach it as well. I'm not clear on how you're running into problems with the sums, I've done this before and it's a matter of getting the level of detail in the view and/or filters working properly. One thing I've used is to add an additional column to identify the format used, then use calculated fields for returning % vs. numeric values. Also, in Tableau v8 you can take advantage of the new Label Shelf functionality by having two measures on it, one for your % values and the other for numeric.