Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Update:
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.
Message was edited by: Janet Whiteman
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.
Thanks. I tried rebuilding it from scratch and i still have the SORT BY EXPRESSION unchecked.
Sort by expression and also sort by state by auto ascending. it will work