Percentages on Crosstab

[gatorfe]

We are working on a simple crosstab(pic attached) but having an issue trying to get a percentage to work.  We want to add a new column that includes the % by category for each month.  So for the 1st row of the cross tab where the category is blank the percentage should be .862 (10169/11791).  The category DRP should be .013(154/11791).  We see in the query the total fields per month and per order source(pic attached).  How can we create the calculation we are looking for?  Thanks in advance for any suggestions. 

[BigChris]

Have you tried a calculation that's something along the lines of:

total ([Order No] for [Order Source]) / total ([Order No] for report)

There are probably more elegant ways to achieve the same thing though...

[gatorfe]

Thanks Big Chris!