Pivot table and value range

[Nicawette]

Hi,

I have built a simple pivot table with 2 columns : Amounts and count
of amounts

eg:

amount/Nb of amount
100 /1
150 /5
200 /6
250 /2
300 /1
450 /5
500 /9

Would it be possible to have a range of value in the pivot table to
have a result like this:
amount/Nb
0-200 /12
201-400 /3

401 /14

Thank you for your help

Thank you

 

[Dave Peterson]

I would add a column to the raw data that categorized the amounts.

if(a2<=200,200,if(a2<=400,400,"400+"))

Then drag this down the data. And use it as the field in the pivottable.

 

[Nicawette]

Thank you for the answer, excel 2007 is providing a tool to do it
easily under pivot table tools, option, group selection.