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|
How then do I make sure that all the months are shown.
Thank you in advance for your help.
Abhilash Kumar replied
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 :