Step 2: Go to the Analyse tab > under Group section click Group selection. Step 1: To group by dates in Months, select any cell on the data in the Pivot table. Similar to the way we grouped Years, we can also group by Months. You can see from the below image that the pivot table has listed the data grouped by years. ![]() Step 4: In the Group Selection box, select ‘Years’ from the ‘By’ list. Step 3: To group by dates in years, Go to the Analyze tab > Group Selection. You can see the values displayed in the worksheet in the below image. So, drag and drop the ‘Date’ heading to Rows, and Sales to Values. In this example, we are going to group the data by years. ![]() ![]() Step 2: In the Pivot table fields you will find all the headings of your data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |