Problem with cross tabs

[surima]

Hi All,
I am stuck up in a typical cross tab issue as shown in attachment.
The SQL query retreives the area office,sourcing types,amounts,and appl no. The problem lies in display of %to Total for number and amount.


Thanking in advance.
Regards.

 

[mikelm3]

percentage of the field as a place in your Crosstab row and the summary of that summary row as the row percentage