Hi there,
I have a Cross-Tab set up that has a list of store location #'s by row and then a list of accounts across the
columns. It is totaling up the number of transactions by count and $sum of each each store # to each account
The count/sum of transactions fields are made up of 4 txn types (ex: DR, DR correction, Transfer, Transfer correction) and currently is counting for every type. I need to edit the count so that I can subtract the total number of txns by the other 3 txns types. (Similarly need this for the $value)
Is there a way to add in a formula to the cross tab that would give me a count of "DRs - DR Correction + Transfer - Transfer Correction?"
Thanks!
Running Crystal 11 - 14.0.2.364
I have a Cross-Tab set up that has a list of store location #'s by row and then a list of accounts across the
columns. It is totaling up the number of transactions by count and $sum of each each store # to each account
The count/sum of transactions fields are made up of 4 txn types (ex: DR, DR correction, Transfer, Transfer correction) and currently is counting for every type. I need to edit the count so that I can subtract the total number of txns by the other 3 txns types. (Similarly need this for the $value)
Is there a way to add in a formula to the cross tab that would give me a count of "DRs - DR Correction + Transfer - Transfer Correction?"
Thanks!
Running Crystal 11 - 14.0.2.364