15. Using the data from Hands-On Exercise 13, cre- ate a pivot table that displays the total revenue by salesperson for each week. (Hint: Use grouping.) (Refer to worksheet"6.15".) B IV a H12 + x V fx 00 NM - N 00 00 2 March Sales 3 Salesperson 4 Mary 5 Mary 6 Mary 7 Mary 8 Mary 9 John 10 John 11 John 12 John 13 John 14 John 15 Henry 16 Henry 17 Henry 18 Henry 19 Henry 20 Henry 21 Henry 22 Susan 23 Susan 24 Susan 25 Susan 26 Susan 27 David 28 David 29 David 30 Danny 31 Danny 32 Danny 33 Danny 34 Linda 35 Linda 36 Linda Date of Sale Product Sold 30 books vacuum 21 vacuum 16 candels 21 books 25 vacuum 29 candels 2 vacuum 12 vacuum 3 candels 9 candels 13 books 1 books 31 books 20 vacuum 24 candels 5 candels 28 candels 11 books 6 candels 31 vacuum 25 books 25 candels 11 vacuum 9 books 17 candels 7 vacuum 8 vacuum 12 books 4 books 13 candels 12 candels 28 candels Units Sold Transaction Revenue $5,400.00 $1,400.00 $2,597.00 $4,096.00 $2,125.00 $216.00 $504.00 $816.00 $1,248.00 $73.00 $1,875.00 $204.00 $4,032.00 $3,328.00 $1,536.00 $56.00 $702.00 $864.00 $3,840.00 $91.00 $5,696.00 $4,214.00 $2,050.00 $1,440.00 $2,448.00 $6,885.00 $5,184.00 $1,850.00 $1,925.00 $2,275.00 $3,087.00 $3,185.00 $2,891.00 0 0 00 ni 38