any thoughts on this?

Sorry for the long post.  Hopefully all this makes sense.   Thanks in advance for any help.

This is what I need included in the cross tab
       Rows:
               State                     (Group 1 in report)
               Referral Type         (Group 2 in report)
               Facility                   (Group 3 in report)
       Columns:
               Total RNQ                     (Return not qualified)
               Total RHI                      (Returned has insurance)
               Total Approvals             (Patient accounts that we have accepted)
               Total Returns                 (Patient accounts that we have rejected)
               Gross Conversion Rate  (Percentage of accounts approved)
               Net Conversion Rate (percentage of accounts approved minus returns)
               Total Accounts           (per facility, per referral type, per state)

The intersections of the cross tab need to be the results for those calculations.  All of the totals are running totals, all of the rates are formulas that use the running totals.  Both the running totals and the rates are in the Group 3 (Facility) footer.

I have figured out how to get the rows set up.  But since the columns and intersections are completely custom, that part is trickier for me. 


fields in the data source are:

Facility                        (hospital)
Referral Type              (Reason for stay)
Referral                      (date referred to us)
Name
Account Number
MR Number
Status Order
MANumber
Status                        (RNQ, RHI, approvals and returns)
Action Summary
I/O/E
Admission
Discharge
DOB
State
Zip
Applied For
Applied For 2
Applied For 3
Date Applied for 3
Approved For
PEN Date
PEN+ Date
APP Date
BAP Date
BAPD Date
BAPR Date
Financial Class
Fee
Charges
Total Medicaid
Commisisons
Outreach
Charity Status
Diagnosis
Application Date
HospServ
Chief Complaint
Email
< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 11">< name="Originator" content="Microsoft Word 11"><>  

'fraid I'm late for an appointment, but to get you started, first, you need to create formula fields for the intersects. for instance for Total Rnq, create a formula field called TotRnq. The calculation will be "if {status}='RNQ' then 1 else 0"without the outer quotes of course. This will count each record with Status =Rnq, Move that to the insteresect section with the default function of "sum".  I'll try to get back to you later today. Hope this helps.