On one of my reports I have got column charts based on a query. Report is also based on the same query. On the chart there is field ‘Faults’ on x-axis and ‘Qty’ on y-axis. The Qty field in underlying table is set to ‘1’ as default. So in chart it sums up Qty values.
At the moment chart is displaying Fault quantities in Fault ascending order. I want it to display ‘Faults’ (x-axis) in descending order of total Qty. I have tried to change sort order in Qty, and Fault fields in query but no effect.
Can somebody advise me where do I need to change the setting.