Skip to Content
avatar image
Former Member

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 2015 May 2015 Jun 2015 Jul 2015 Total A 100 100 400 200 800 B 300 400 600 200 1500 C 300 200 100 300 900 D 300 400 300 100 1100 Total 1000 1100 1400 800 4300

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

Thank you in advance for your help.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 27, 2015 at 10:54 AM

    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 :

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded