Would be grateful for clarification on how you have arranged your table.
If you are using the MeasureNames/MeasureValues,
I think you should be able to create a new calculated field called Total
and sum up the other measures. That should then get you the row by row
If you are using Pivoted Fields, I don't think you can add a calculated field to the Pivot.
But you could do so in Tableau Prep.
Would be grateful for a screenshot that includes the locations of the pills
on the Columns and Rows shelf and on the side shelves.
Please see workbook v10.3 attached in the Forum Thread.
283336sets.twbx 1.3 MB