Skip to main content

Grouping in Pivot table

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

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more