What was the percent of total 2013 quantity of orders for Distribution Center of CS?
marketing
Description
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
