This works if we have Text tables with Single Measure, because the calc converts to string instead of number. I tried INT(calc), but not working.
But I do have some other Measures should be displayed along with this as dual axis. However i cannot make dual axis which has String & Numeric values. Any suggestions please!
Create calc as [$ label]
if [Measures]='Sales' then '$'
elseif [Measures]='Quantity' then '$'
Create 2nd calc as [% label]
if [Measures]='Calcs' then '%'
Drag the both into text.
Edit text and add first calc and 2nd as
<$ label><AGG(calcs)><% label>
now based on selection the $ and % will change.
BI, Aspire Systems (India) Pvt Ltd
Formatting_$-% -Parameter.twbx 596.6 KB