I am trying to design the table looks like :

 

Hour   mon  tue  wed ... sun  total  %

 

1         100  200  300  ... 200  1000  11%

2

3

...

24

 

total

 

%

 

I tried to design this table using cross tab, but I can't as I cannot add % column and row in cross tab..I already have total column and row so... (if I could please let me know )

 

So I tried to build this table using Group expert (group by hour) and then tried to display values depending on the day of week... but I am stuck here.

 

I need to display the count value corresponding to 'day of week' and 'hour'

How do I make this type of report ?

 

Thanks,