Please find attached workbook.
Sum(Sales) with % is not meaningful. Please change to percent of total in sales and add it.
Create calculation [Measure Calc] as
case [Select Measure]
when "Profit" then SUM([Profit])
when "Sales" then SUM([Sales])/total(SUM([Sales]))*100
Create two separate calculations for label.
[% Sales label]
if [Select Measure]='Sales' then '%'
[$ Profit label]
if [Select Measure]='Profit' then '$'
Drag category into row. Drag [Measure Calc] into text and select compute using category.
Drag each label into text.
Align the text as follows
<$ Profit label><AGG(Measure Calc)> <% Sales label>
BI, Aspire Systems (India) Pvt Ltd
Formatting_$-% -Parameter.twbx 603.9 KB