I know that you can group dates in Pivot Tables to show weeks, months,
quarters, etc.
I want to know if is possible to group other things
for example, i have values in a field like 20, 31.5, 46
and would be nice to have groups of five
(20-25, 25-30, 30-35 and so on)

Almost forgot
is in Excel 2007

"Alonso" wrote:

I know that you can group dates in Pivot Tables to show weeks, months,
quarters, etc.
I want to know if is possible to group other things
for example, i have values in a field like 20, 31.5, 46
and would be nice to have groups of five
(20-25, 25-30, 30-35 and so on)

Hi,

Simply click on Group Fields under Pivot Tables Options Group

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Alonso" wrote in message
...
I know that you can group dates in Pivot Tables to show weeks, months,
quarters, etc.
I want to know if is possible to group other things
for example, i have values in a field like 20, 31.5, 46
and would be nice to have groups of five
(20-25, 25-30, 30-35 and so on)