How to other grouping of Pivot Table
Now in this video we will see that how we can group data other than pivot table method.
Suppose if we want the two columns data of pivot table together in one column, so for that we will use group option.
First of all we will select 2 columns from pivot table and then right click on them and select 'group' option, this will get them both together in one group named 'Group1'.
Data will also be manipulated according to that.
We can also menu plate over data according to this in Rows. We just simply need to select our two rows and right click on them and select our 'group' option.
We can also ungroup that data, by just right clicking on the group and select 'ungroup' option.
Share a personalized message with your friends.