SOS. Total in Cross Tab is not working correctly.

Hello Everyone!

I have 2 CrossTab reports.

The first one shows:

Property Sq.Footage

The second one shows:

Amount per Account

I am using CrossTab only because I need dynamic number of Account columns.

In the Total of the first CrossTab I am summarizing SF.

In the second CrossTab's Total I am trying to calculate Amount / SF, which works fine in detail section, but doesn't in the Total.

Please let me know if you have ay further question.

Thank you.