Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CrossTab data presentation.....

Honestly I am new in crosstabs and asking for major help.

I have to present data from a database in a tabular format(crosstabs).

The user inputs the time period in which theĀ  data should be drawn and according to those dates the tab is drawn.

So lets say date range is between 14 April 2015 and 16 July 2015.

Then the table should look as below

Apr 2015May 2015Jun 2015Jul 2015Total
A100100400200800
B3004006002001500
C300200100300900
D3004003001001100
Total1000110014008004300

How then do I make sure that all the months are shown.

Thank you in advance for your help.

Tags:
Former Member
replied

Hi Star,

1) Use the date field as the 'Column' of the crosstab. Highlight the row > Group Options > Set it to print 'For Each Month'

2) Use the field under 'Row'

3) Place a field under Summarize Fields for the summaries.

If there are missing dates (because data doesn't exist in the database) then look at this thread :

Displaying all missing dates in a range

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question