To summarize the data i am going to use pivot table. First I am going to select INSERT and then select Pivot table.
Then a new window is going to pop up and i am selecting the pivot table to be generated in a new sheet.
I am adding Region to the Rows and then Profit to the values.
We can observe the region wise profits and total profit using pivot table.
If we want to know the profits in the regions based on the sub categories we can add sub category field to the column. Then the result would be as follows :
If we want to summarize the data, we can change the values. For example if i want to check the maximum profits for every subcategory instead of sum of profits i can change in the values as follows :
Then the data in the sheet is converted to represent maximum profits for every subcategory in the regions.
Or if i want the result to be displayed in percentage then i cahnge the values to be shown as percentage.
The data in the sheet is changed to percentage.
Then again the Profit values are changed back to default.
And now i want have data of sub categories with maximum profits greater than 100. So i am going to add a filter to the profit field.
I am going to add the condition to filter the data.
We can observe the profits below 100 are not visible in the sheet anymore.
Thus the data insights can be summarized from the data using pivot tables.
