I have a tracking spreadsheet that I maintain. It tracks cases that can appear multiple times at various intervals, so I have created a unique identifier for each case.

I have two data fields I need to compare: Total Prospects, and Sum of Total Rating Time. I have created a Calculated Field that contains an IF statement. If the sum of the total rating time is zero it returns a zero, else a 1.

I now need to have totals by other pivot table fields of that Calculated Field. They currently return 1s.

Is there a way to calculate the subtotals by other pivot table fields?

Is there a better way to get the information I need?

I really appreciate any help.

Thank you,

Audrey