OCW Numeric intervals in ASP

[Ivan]

I'm formatting the returned data to show the total per loan amount.
However, since there's are some many loan amounts I would like to know how
to group these using ASP code. Manually it easy, as you go click on the Row
that I want to group, choose Commands and Options and grouping.
BUT how do I do this using ASP? I can't the information anywhere to do this
programmatically.

now it displays
Amt Total
0 10
8 50
15 20
37 5
65 15

and I want it to display
Amt Total
0-10 60
10-20 20
30-40 5
60-70 15

thanks,
Ivan

 

[Ivan]

After digging and digging finally found the solution...

With pivottable.activeview.fieldsets("amount").fields(0)
.GroupOn = PivotTable.Constants.plGroupOnInterval
.GroupInterval = 10
.GroupStart = 0
.GroupEnd = 100
end with