on 05-05-2009 7:18 PM
Hi,
Running XI 11.0.0.1282.
I have to summed fields in my crosstab: Payments and PreviousBalance. I need to calculate and display the percentage of payments.
I've gone into the Crosstab Expert and added both fields to the crosstab. When I highlight the Payments, Change Summary and select Show as percentage of; the only option to select is itself.
How do I get the Payments to show as a percentage of Balance?
Neither of these fields are formulas. They are both summed, not counts or averages, but I can't get the percentage to point to any other field.
Thanks,
Brian
I figured out the problem. I need to have more than 1 row (Group), which I don't because all my grouping is done in the database beforehand.
Looks like I'll have to think of something else.
Thanks,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.