Data format

[Anonymous]

I have a staright table with measures as sales and quantity and have two buttons for selection(sales and quantity).

On clicking sales button it will display the sales values and on clicking the quantity button it will dispaly quantity related values.

My requirement is when i will click on sales button it should show me the vlaues in price format and the quantity values in number format.

Can anyone please help me on this ?

[SunilChauhan · Accepted solution]

hope you using some variable

so you can use like below

if( var=Value NUm(value,#.##0,00 kr;-#.##0,00 kr),NUm(Volume,'#,##'))

hope this helps

[#3]

Hi,

You can create two expression and hide/show expression using condition hide and give different format to each expression in properties of chart -> Number tab.

Hope it works.

Shameem.

[Anonymous]

It worked fine now.

Thanks all for your help

[SunilChauhan]

Please marked it as correct  for future refrence