Pivot table and value range

  • Thread starter Thread starter Nicawette
  • Start date Start date
N

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
Click to expand...

Thank you for your help

Thank you
 
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.
 
Thank you for the answer, excel 2007 is providing a tool to do it
easily under pivot table tools, option, group selection.
 
Back
Top