Dynamic Range in a Pivot Table
 

I have a pivot table with 3 columns that I'm trying to manipulate. One column
has values ranging from 0-10,000, another all over 100,000, an ditto the
third column.

I'm trying to find averages in the latter two based on ranges in the first.
So, the aveage of the latter two based on the first column like this: 0-1000,
1001-2000, 2001-3000, etc. I've been fooling around with for about an hour
with no luck.

Can anyone give me a quick/easy or good way to accomplish this using
pivotables?

Thanks