For each dimension calculate % change in Qty (Column K) between the first part and the second part of 2013 (hint - create an additional column that will create a field putting each purchase order in the relevant part of the year. Use 6/1/2013 date as a delineation between the two parts of the year.) Then do a pivot table.
Calculate % of Total for each dimension member as well
Answer the questions below by filling in a blank with rounded integers.
QUESTION 1 - Among countries - what was the highest percentage increase in the quantity of orders between the first and the second part of 2013. Enter the number as an integer
QUESTION 2 - For the country of US, what was the percentage of total 2013 quantity of orders? Enter the rounded integer number
QUESTION 3 -What was the percent of total 2013 quantity of orders for Distribution Center of CS? Enter the rounded integer. Answer: 54
QUESTION 4 - What was the percentage increase in quantity of orders between the two parts of 2013 for Distribution Center BU? Enter the rounded integer.
QUESTION 5 - What was the highest percentage increase in quantity ordered between the two parts of 2013 among all buyers. Enter the rounded integer