I'm calculating percentages within a cross tab report and I want my percentage to be based on the Grand Total across the colum and rows not the Subtotal. How do I do this? I've been struggling with it for the past 2days. Here's a sample data. Thank you.

 

          08:00 ‑ 08:59             1                    0                  1

                                           50%               0%              40%

          16:00 ‑ 16:59              1                   0                  1

                                           50%               0%              40%

          17:00 ‑ 17:59               0                  1                   1

                                             0%           100%              20%

                Total                      2                  1                   3 = Grand Total

                                          100%           100%            100%

 

% should be calculated as 1/3 for line 1 and not 1/2. Please help.