April 01, 2009, 10:56 AM
MoogleModify PMF to show dates highest to lowest for all reports and graphs?
Hi,
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:
-*CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
-* the next row sorts the dates highest to lowest
ACROSS HIGHEST &SORTACR_FIELD_AS
&BY_SORTACR_FIELD_COMBO_TIME_NOPRINT
&BY_SORTACR_FIELD_NOPRINT
-* the next row originally showed the dates lowest to highest
-* ACROSS &SORTACR_FIELD_AS
-*CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
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?
Cheers,
Joey
April 01, 2009, 04:34 PM
malapejohnHi,
I think it resides in PMF_analysis_parms.fex , I will get back to you with details
April 03, 2009, 04:21 PM
Bob Jude FerranteThis would be a nice option. I'll run it by our guys.
thanks