I have started to update some existing reports, replacing the older hideous looking charts with the modern versions post 2016 and I've just been through three hours of non productive frustration.
I have a simple query feeding a chart that works fine on the old versions. I can create the chart OK but I'm unable to get the bars to run in Pareto sequence. As soon as I attempt to sort the query in descending order I get
" You can't assign a value to this object"
Any ideas on how to resolve this would be much appreciated.
Thanks
Ian