-
1. Re: Display symbol accordingly by swapping the values in parameter
panjala Srinath Jan 20, 2016 1:30 AM (in response to lalitha p)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
-
2. Re: Display symbol accordingly by swapping the values in parameter
lalitha p Jan 21, 2016 8:19 PM (in response to panjala Srinath)Hi Srinath,
What you are saying is create one more parameter with two values K and % and select accordingly with the other parameter selection .
But this should not be really good idea right., providing one more parameter for the symbol.
It should come (symbol ) automatically with the first parameter selection. If sales then sales with M value and if it is profit % then value with % symbol should display...
Regards
Lalitha P
-
3. Re: Display symbol accordingly by swapping the values in parameter
Shinichiro MurakamiJan 22, 2016 5:19 AM (in response to lalitha p)
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.
-
4. Re: Display symbol accordingly by swapping the values in parameter
pooja.gandhi Jan 22, 2016 7:03 AM (in response to lalitha p)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
-
5. Re: Display symbol accordingly by swapping the values in parameter
panjala Srinath Jan 23, 2016 2:14 AM (in response to lalitha p)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