Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a question. I have a straight table with a calculated dimension:
=if([Account number]='I0100000','Gross Revenue',
if([Account number]='I0400000','Net Revenues',
if([Account number]='I0700000','Gross Margin',
if([Account number]='I0800000','Variable logistics cost',
if([Account number]='I0900000','Contribution',
if([Account number]='I2300000','EBIT TDA',
if([Account number]='I3600000','Net Result'
)))))))
Can I bold only 2 of them? Or maybe change the alignment for only 2 of them?
Thank you
i guess, yes
click on the plus sign of the calculated dimension..
there in the text format.. with the condition try to put '<B>'
for example if you just add ='<B>' there in the text format then your dimension should get bold..
if it happens then put your condition there.
HTH
Sushil
Hello Sushil,
Thank you for your reply. If I put <B> or <i> there is works for every element of the dimension, but I cannot seem to get a condition to work for only 2 of the elements.
If I use the same condition as I do to only limit the dimension to the 7 listed, it does not work, and it's only natural.
Is there a way I can use a condition like
if(dimension='Contribution',<B>) ?
use <B> inside quotes
'<B>'
Unfortunatelly the quotes will not help with applying this format to only one result from the dimension
ok.. is it possible for you to share the sample app
Yes, Sushil, I will try to share it first thing in the morning when I get to the server. I guess we will talk then.
Thank you for your help.
Bogdan