Pivot Table - Count If

[Guest]

I am trying to figure out Pivot Tables. I think that I somewhat understand
it. My question is can I do a "Count If" in a pivot table.

I have a column that has formulas to calculate wait times. In my pivot
table report I want to count if the wait time is 90 minutes or less by each
physician.

Is this possible?

 

[Guest]

Sort the pivot table by physician and run the count function as a subtotal.

Dave

 

[Debra Dalgleish]

In the source data, you could add another column to calculate if the
wait time is 90 minutes or less. For example, if your wait time
calculation is in column G:

=IF(G2<=90,1,0)

Then, add the new field to the pivot table's data area, using the Sum
function.