Pivot table and value range
 

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

Pivot table and value range
 

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 wrote:

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

Pivot table and value range
 

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