Use of Group and Outline in Pivot Table

Hi amanvig1,

If the data you wanted to group is date.. then excel will automatically group them. Else you need to select the range manually and right click and group. I believe it would be helpful if you could upload a sample workbook with some data which you want to group. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>