Pivot table Get Pivot Data where grand total is above a certain number

[jscranton]

I have a pivot table with a lot of data in it. I am summarizing that data using the GetPivotData command. The data contains engagements (thousands of them) and then subtotals for hundreds of different activities. All of the sub-total hours across all activities is the "Grand Total" for each engagement.

This code, for example, is fairly simply for returning the entire total for all hours billed under Hourly Billing.

Set pt = ws.PivotTables("PivotTable13")
hourTotal = pt.GetPivotData("Total_Hours_In_Number", "Activity_Nickname_1", "Hourly Billing")

What I am trying to figure out is how to limit the data to engagements that cross certain thresholds for total hours. So, if I wanted to get the Hourly Billing totals for all engagement that have a total of 1000 or more hours, I would think it would be something like this (But this obviously doesn't work):

hourTotal = pt.GetPivotData("Total_Hours_In_Number", "Activity_Nickname_1", "Hourly Billing", "Grand Total", >=1000)

I know that I can loop through the entire pivot table and get what I need via a loop but I was hoping to save some machine time if possible.

Thanks,

J