Crosstab

[BlurredVision]

Hello, I don't write many cross tabs, but that boss lady really wants.

Running V10 (Also have XI if needed)

I have the following information below: The Payment and Rsvadj are generated from two formulas:

(Payment)
if {CM_PAYMNT.I_E_IND}="E" then {CM_PAYMNT.PAYMENT_AMT}

And

(Rsvadj)
if {CM_RSVADJ.I_E_IND}="E" then {CM_RSVADJ.ADJ_AMT}


CLAIM_NUMBER Payment Rsvadj
2006-143 5,000.00 0.00
2006-143 30,000.00 0.00
2006-143 0.00 50,000.00
2006-143 5,000.00 0.00
2006-143 30,000.00 0.00
2006-143 0.00 50,000.00
2006-143 5,000.00 0.00
2006-143 30,000.00 0.00
2006-143 0.00 50,000.00
2006-143 5,000.00 0.00
2006-143 30,000.00 0.00
2006-143 0.00 50,000.00
2006-143 0.00 50,000.00
Totals: 35,000.00 50,000.00


My issus is, I need a sum of each of my formulas (Which I've placed in the summarized section of the crosstab) But, the crosstab continues to total up each row.
Payment is equal to 140,000.00 and Rsvadj is equal to 250,000.00

I would like the totals to be 35,000.00 for Payment and
50,000.00 for Rsvadj.

I can get the totals correct with a running total, but it would seem that you can't use a running total within a crosstab.

Would like my crosstab to look something like this:


________________
| Total |
________________________________|_______________|
2006-143 | 35,000.00 |
| 50,000.00 |
________________________________|_______________|
Total | 35,000.00 |
| 50,000.00 |
________________________________|_______________|

Thanks for any help given..

 

[lbass]

You should use XI then so that you can use running totals in the crosstab.

-LB