Bar chart in WAD

Hi All,

I have Vehicle and Supplier in the rows and key figures 01, 02, 03 in columns, this query is used in the wad template where the user can select the required KF(can be multiple)

1) i need the keyfigures to be displayed in descending order by its value, i used condition bottomN but the problem is i defined the condition on each KF but seems like its not working when i filter by choosing the KF's.

2)the values of the barchart are displyed as 1,23 insted of 1.23, tried to format it as number 0.00 but doesnot work

3)i have two characteristics in row vehicle type supplier

the result is something like this

vehicle supplier KF1

veh1 XYZ 1.1

veh2 abc .99

veh3 xyz 0.1

veh4 abc 2.2

can i display all the vehicles belonging to XYZ in one color and abc in other color, i can diaply the bar graph something like this now

veh1/xyz 1.1

veh2/abc .99

veh3/xyz .1

veh4/abc 2.2

Thanks,

Shetty.