CrossTab data presentation.....

[Former Member]

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.

[abhilash_kumar · Accepted solution]

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

[Former Member · Accepted solution]

Thank you Abhilash

Where do I edit so that it shows as Apr 2014 not 2014/04

[Former Member · Accepted solution]

Figured it out. Thank you a lot for your help.