Grouping in Pivot table This feature is mostly helpful when row label data is in numerical values or dates. Step 1: Create pivot table, go to row label data and right click Step 2: Select option “Group” Step 3: From the dialogue box Grouping enter the number against within range of start and End values, then click on OK Now we can see the data in group wise or bucketed data