I have a Crystal report with a crosstab that contains two columns of numbers. These numbers are "distinct counts".
I would like to generate three more columns:
1. Sum of the two columns (I created a calculated member for this column, which is working and giving me the correct value)
2. 1st column percentage of the total.
3. 2nd column percentage of the total.
What formula(s) do I need to use to do this?
Thanks.Field1 Field2 Total Field1 % of Total Field2 % of Total 10 90 100 10% 90%