Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
To check if you're on the total row, use if(rowno()=0,num(expression,'#.###'),num(expression,'#,#'))
Regards,
Thanks for your reply .. but..
that only works on a pivot .. not on a bar chart
Hi Amien,
try Dimensionality() instead. It worked for before in colouring the bars differently, maybe it behaves the same for you.
cheers
Florian
Nope .. total doesnt react
rowno()=0 works on bar charts as well. Dimensionality, by contrast, works only on pivot tables.
Regards,