Question 21: Did GBI ever gain or lose a customer (based on revenue)? Explain 32. Include only Calendar Month in Rows. Calendar Year in Columns. Revenue in Values. Notice that the Months may be sorted as text (rather than numerically). Resort them manually (if needed) in the correct order (1, 2, 3 ...12). You can do this by selecting a cell, then hover over it until you see a four headed arrow. Then drag and drop to order correctly. 33. Insert a Pivot Chart. Choose Line chart. Question 22: Is there seasonality in revenue during the year? If so, what month has the highest revenue? Is the seasonality similar from year to year? 34. Remove the Chart. Include only Material Desc in Rows. Calendar Year in Columns. Revenue in Values. Question 23: Which product shows dramatic change in revenue over time (years)? Does it have the same change by country? (Hint: You will have to add a field to your analysis to answer the second part of this question.) 35. Include only Material Desc in Columns. Calendar Month in Rows. Revenue in Values Insert a Pivot Chart. Choose Line chart. 36. Select the material that shows the highest peak (in the chart). Right click [ Filter [ Hide Selected Item. Continue removing the next highest material until you see a low seasonality material (relatively flat line). Question 24: Which material does not display significant seasonality