I want to use Pie chat in the reporting module. Query return results in following format.
BL line CL line Keg line Office Ro
500 200 300 150 100
How can I transpose the query result, there is no ‘extract order’ property in the Pie Chart Reporting module that is an option in Pie chart in Designer
In designer we have an option under the Data heading to Extract Order, by Column or by Row.
This option is not available in the reporting pie chart that we can find. Our quire is complicated and not easy to change.