Click to See Complete Forum and Search --> : Please help! how do I design this report?


zakal1983
November 26th, 2009, 05:08 PM
Hello everyone,

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,