I have created pivot charts where the Sorting is by Expression. It is working on Desktop but once i migrate to the server and look at it from access point, the sorting goes away. Any clues?
I noticed that its really not removing the sorting even though the SORT BY EXPRESSION is UNCHECKED. But the sorting is being overriden after the reduction happens. So it is apparent to "USER" access and not with "ADMIN" access.
Still dont know how to fix it though. Any help would be appreciated.
Re: SORTING by expression not checked on Access Point
Whether our problems are related or not is beyond me, but I've had issues before where I've had options set to one thing in developer but they showed up different on Access Point. In order to fix it, I just recreated the chart from scratch.