Pivot Table Grouping

G

Guest

Hello,

I would like to create my own grouping for data in a pivot table. What
would be the best way to accomplish this. My groupings are <=200, 201 to
500, 501 to 2500, >=2500.
Thanks
 
G

Guest

I don't think PivotTable supports this, but you could group the data using a
formula, and then have the pivottable data range refer to the formula's
results. Looks like your set of groups is limited enough that you could use
an IF formula to create the groupings.
 
D

Debra Dalgleish

With numbers in column A:

=IF(A2<=200,"a) <=200",IF(A2<=500,"b) 201-500",IF(A2<=2500,
"c) 501-2500","d) >2500")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table and value range 2
grouping multiple tables Excel 2007 3
Pivot Tables with different groupings based on same data table 6
Pivot ungrouping on refresh? 3
Summing Contiguous Values in a Column? 6
Grouping by month in a Pivot Table 1
pivot table counting 1
Change quarters in Pivot table when grouping 1

Top