on 02-15-2013 9:44 PM
I have a Cross Tab that shows the last 6 months, ie, Aug (2012), Sept (2012), Oct (2012), Nov (2012), Dec (2012), Jan (2013).
What's the best way design so that the months on the Xtab update automatically instead of making me go in and change the specified order each time I run the report? Many thanks in advance!
| Aug | Sep | Oct | Nov | Dec | Jan |
|---|---|---|---|---|---|
| data | data | data | data | data | data |
Hi Leslie,
If you follow Jamie's suggestion there will be no need for a 'specified' order grouping and the 'sort' will always be perfect.
Just in case you want to pull last 6 months data in the report each time when it is run, then refer following thread:
http://scn.sap.com/thread/1489222
Thanks,
Prathamesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Leslie,
i am assuming that you've already got a record selection formula that gives you the last 6 months and you only need help with the crosstab order...if you do need the record selection as well please let us know.
for the crosstab though, the easiest way is to change the column field to the date in the crosstab expert and then in the crosstab expert, click on the date field and choose Group Options, and change the "Column will be printed" option to "for each month".
now go to the preview mode and right click on the column header and choose Format Field and then go to customize the Date so that the Month is using the "Mar" format and that Year and Day display None.
the order of the columns will be based on the date field so that you don't need to reorganize anything.
cheers,
jamie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.