I would like to see a report with an output such as
13/02/2006 14/02/2006 Total
Morn Aft Eve Morn Aft Eve
Mr A 2 4 5 2 6 2 21
Miss B 8 8 1 1 4 5 27
I have a DB table which records the datetime each time a viewer changes TV channel. The report is a summary by user of each channel change By Day Part with Each Date
I can do this easily enough by just grouping on Date but now require another level of detail.Ok keep date as your first category, but group day part as a subcategory. You may need to represent the day part numerically, ie morn =1, aft = 2, eve = 3, then you will be able to srt in ascending order the dispalay morn aft eve. I hope this helps, i came across something similar the other day.|||I don't think you can have Subcategories in a Matrix, the only similar thing I've tried was to add a second grouping to the Column Grouping. The output of this does not sub group the data in Day parts it simply displays the Date with the first Day Part appended, however it doesn't sub group by Day Part
No comments:
Post a Comment