Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Grouping dates in a pivot table | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Worksheet Functions | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |