ExcelBanter - Pivot Table Grouping

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Grouping (https://www.excelbanter.com/excel-discussion-misc-queries/102687-pivot-table-grouping.html)

Karen

Pivot Table Grouping

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

Eddie O

Pivot Table Grouping

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.

"Karen" wrote:

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

Karen

Pivot Table Grouping

Hi,

Any suggestions on how to create the IF formula to create the groupings.

"Eddie O" wrote:

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.

"Karen" wrote:

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

Debra Dalgleish

Pivot Table Grouping

With numbers in column A:

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

Karen wrote:
Hi,

Any suggestions on how to create the IF formula to create the groupings.

"Eddie O" wrote:

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.

"Karen" wrote:

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

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 08:54 PM.