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
Bookmarks