Percentage in a summary report layout

[RyanESmith7]

I have created a sales summary report layout for my DB and the totals are working great, but for some reason, the percentages make no sense. This is a sub summary on two fields (Account Rep and Job Type). 

 

The Total Sales Amount column is a summary field based on the Sales Amount. 

 

Currently, the percentage is a calculated field based = Sales Amount / Total Sales Amount. 

 

Basically, I want the percentage to be the percentage of the 4th column compared to the grand total at the bottom.

 

What am I doing wrong?

 

(Report is attached) 

 

Thanks,

Ryan

 

[eos]

See if this helps you.

SubSummary_eos.fp7.zip

[RyanESmith7]

This was a HUGE help, thank you so much!