My client is used to reading reports with the newest time periods showing on the left and then historical periods going to the right. A report such as the Rolling 5 Measures (a_5_meas1.fex) shows the time periods lowest to highest.
I can modify a specific report like this:
-* the next row sorts the dates highest to lowest
ACROSS HIGHEST &SORTACR_FIELD_AS
-* the next row originally showed the dates lowest to highest
-* ACROSS &SORTACR_FIELD_AS
I DO NOT want to do this for all my reports and charts. What I'm looking for is a way to do this in one place and have it cascade to all / most of PMF. I think the key is the &SORTACR_FIELD_AS variable.
If I can modify the process that builds that variable to include the word HIGHEST, than I think that would do what I want. How is that variable built, and where?
-WebFOCUS 8.2.01 on Windows