Hi,

I have a 200,000 row table that contains a list of payments made by my
company over the past year. The relevant columns in the table are payment
number, payment type, payment date, payment month, and payment amount (the
table also includes other info like payee name & address, etc.)

I created a pivot table that uses the payment type (wire, ACH, or check)
for the row label and the payment month for the column label. The pivot table
counts the number of payments for each payment type for each month. I have a
second pivot table with the same setup except that it shows the sum of the
payment amount instead of a count.

I'd like to modify the pivot table to give me this same data (count of
payments by payment type) but with info only for payments that were less than
$5,000.

Any thoughts on how I can do this?

Thanks much,

David