number format on total

[amien]

is it possible to give the total of the bar chart a own number format? so i need on all values 0.0 .. instead the total . that needs to be 0.000

[vgutkovsky]

To check if you're on the total row, use if(rowno()=0,num(expression,'#.###'),num(expression,'#,#'))

Regards,

[amien]

Thanks for your reply .. but..

that only works on a pivot .. not on a bar chart

[#4]

Hi Amien,

try Dimensionality() instead. It worked for before in colouring the bars differently, maybe it behaves the same for you.

cheers

Florian

[amien]

Nope .. total doesnt react

[vgutkovsky]

rowno()=0 works on bar charts as well. Dimensionality, by contrast, works only on pivot tables.

Regards,