Pivot Table gives us the summary of sales & profit for each customer segment. Similarly, drag and drop Profit to the Values section (just below sales) to the Profit summary. Pivot Table has given us the summary of sales based on Customer Segment. Step 2: Now drag and drop the Sales column to the Values section. Step 1: Drag and drop Customer Segment to Rows. What are the Total Sales & Profit for each Customer Segment? Finally, we will try to answer a few questions to know the usage of the pivot table. Next, we will see how to use the pivot table with the same data. Now, we know how to create a pivot table using features. Likewise, we can create pivot table in excel by using all the above features. For instance, if we want to filter based on Region, then drag and drop the Regions column to the filter area.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |