Need a crosstab of % of payments to charges with discharge date on vertical and payment date on horizontal. See attached sample.
In crystal, I have created a formula for total charges, total payments, and %_Paid (Charges/Payments), but they don't seem to work in the crosstab the way I need them to.
Any help would be appreciated. I must be missing multiple steps.
I have attached an excel sample file of the way it should look when completed
and a screenshot of the way I have my crosstab set up currently.
I have a sequel query that has fields for payment month and year, discharge month and year. Attached is a word document which shows the crosstab setup - not the way I like it - so hoping someone knows how to set this up the way I need it.