cancel
Showing results for 
Search instead for 
Did you mean: 

How to auto update Cross Tab as months roll forward in specified order

Former Member
0 Kudos

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!

AugSepOctNovDecJan
datadatadatadatadatadata

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thank you!  I will need this for some of the other reports in this series! 

Answers (1)

Answers (1)

JWiseman
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thank you !  Worked like a charm.

Now, I have charts that are based off the Cross-Tab.  The dates there appear as date/time and I can't figure out how to change them to month names.

Many thanks!

Leslie

JWiseman
Active Contributor
0 Kudos

hi Leslie,

can you please post this as a new question to the forum.

thanks,

jamie