Hi

I will not say a direct solution is possible to it , if this compulsory there can be a workaround that may require you to create 2 Calculated fields

1. Calculation One

     "K"

2. Calculation Two

     "%"

Then you can swap these fields using parameters

then adding it to labels along with the original numeric value.

Hope this will at least help you in achieving it but its a lengthy procedure for just a small requirement

Regards

Srinath. Panjala

I guess you need this?

**** Assuming [Sales] <1 can be ignored and [Profit %] never go beyond 100%  ******

Several calculated field.

Report as parameter,

For Header

[Selected Header]

if [Report]="Sales Report" then [Product Category]

elseif [Report]="Profit% Report" then [Product Sub-Category]

END

Then,

[Selected Value]

if [Report]="Sales Report" then sum([Sales])

elseif [Report]="Profit% Report" then sum([Profit])/sum([Sales])

END

From here two more calculated fields.

Selected Value (%)

if [Selected Value] <=1 then [Selected Value] end

Selected Value (Sales)

if [Selected Value] >1 then [Selected Value] end

Put both fields in text.

Calculation automatically hide text which does not match the  conditions as null.

Thanks,

Shin

9.0 attached.

All you need is 2 CASE statements and place both of them on 'label' on the marks card and arrange the 2 pills on labels side by side by clicking on those 3 dots:

Calculation1:

CASE [Select a Measure]

WHEN 'Sales' THEN ([Sales])

WHEN 'Profit %' THEN ([Profit])

END

Calculation2:

CASE [Select a Measure]

WHEN 'Sales' THEN 'K'

WHEN 'Profit %' THEN '%'

END

Hi lalitha p

You can swap the symbol with newly created calculation based on existing parameter of your (Sales/Profits)

it is required to create another parameter. Hope you know this, A parameter can be used in multiple calculations.

Regards

Srinath