Hi,
I am trying to sum total the two values as below but Grouped per day ONLY, 1 total for the 7th, the 8th etc. etc.
However I need the TmHour to filter the results just between those times
This causes it to no longer be grouped by day but per time hour also.
I just can't work this out, any ideas?
Thanks I/A
table below is with the TmHour ticked to show the format (not as above) for the example.
Unticked it still shows the several results per day.
I am trying to sum total the two values as below but Grouped per day ONLY, 1 total for the 7th, the 8th etc. etc.
However I need the TmHour to filter the results just between those times
This causes it to no longer be grouped by day but per time hour also.
I just can't work this out, any ideas?
Thanks I/A
table below is with the TmHour ticked to show the format (not as above) for the example.
Unticked it still shows the several results per day.