| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping a range in pivot without standard to from
On the pivot table, I want to gropu a range.I do see an option of grouping it
is based on some range but can define only one "By". for example give me range for 1-100 and split it in "By"- 10, this means, the range will be 1-10 , 10-20 etc... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Grouping a range in pivot without standard to from
Yes, but what do you want to do? In other words what is the question?
-- Thanks, Shane Devenshire "MG" wrote: On the pivot table, I want to gropu a range.I do see an option of grouping it is based on some range but can define only one "By". for example give me range for 1-100 and split it in "By"- 10, this means, the range will be 1-10 , 10-20 etc... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot : how to put more than one range of data in data area of a | Excel Worksheet Functions | |||
| How do I get the grouping dialogue box to appear in Pivot Tables? | Excel Worksheet Functions | |||
| grouping in pivot tables | Excel Discussion (Misc queries) | |||
| Pivot table, grouping by formula | Excel Discussion (Misc queries) | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Linear Mode
