View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Grouping in Pivot Tables

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)