Skip to Content
0
Former Member
Nov 03, 2014 at 08:59 PM

Calculating percentage in a crosstab

1087 Views

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%