Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create the following 4 Show Values As PivotTable Calculations in a single PivotTable. Create the PivotTable on a this sheet. 1) Monthly Net Sales 2)

image text in transcribed

Create the following 4 Show Values As PivotTable Calculations in a single PivotTable. Create the PivotTable on a this sheet. 1) Monthly Net Sales 2) Running Total for Net Sales for each month 3) Difference From Previous for Net Sales for each month 4) % Difference From Previous for Net Sales for each month Then add a Slicer for Company. Invoice Number Date Company 659439 1/1/2013 Gel Boomerangs 659440 1/2/2013 Tri Fly 659440 1/2/2013 Gel Boomerangs 659440 1/2/2013 Tri Fly 659441 1/3/2013 Gel Boomerangs 659441 1/3/2013 Gel Boomerangs 659442 1/4/2013 Gel Boomerangs 659443 1/5/2013 Gel Boomerangs 659443 1/5/2013 Gel Boomerangs 659444 1/5/2013 Tri Fly 659444 1/5/2013 Gel Boomerangs 659445 1/5/2013 Gel Boomerangs 659445 1/5/2013 Colorado Boomerangs 659446 1/5/2013 Colorado Boomerangs 659446 1/5/2013 Colorado Boomerangs 659446 1/5/2013 Gel Boomerangs 659446 1/5/2013 Gel Boomerangs 659446 1/5/2013 Gel Boomerangs 659446 1/5/2013 Gel Boomerangs 659447 1/5/2013 Colorado Boomerangs 659447 1/5/2013 Colorado Boomerangs 659448 1/6/2013 Colorado Boomerangs 659449 1/7/2013 Gel Boomerangs 659450 1/8/2013 Gel Boomerangs 659451 1/9/2013 Tri Fly 659451 1/9/2013 Tri Fly 6594521/10/2013 Colorado Boomerangs Product Quad V-Rang Carlota Darnell Quad Carlota Quad Quad Bellen Darnell Bellen Carlota Yanaki Mt. Fun Yanaki Net Sales Cost $616.22 $295.79 $56.40 $26.51 $178.75 $96.53 $391.52 $207.51 $80.24 $43.33 $198.00 $99.00 $396.00 $209.88 $648.00 $336.96 $251.55 $125.78 $393.84 $189.04 $232.48 $118.56 $206.25 $99.00 $57.00 $27.93 $112.08 $56.04 $243.40 $121.70 $529.00 $285.66 $288.00 $135.36 $392.14 $188.23 $672.24 $315.95 $12.12 $6.30 $208.00 $110.24 $83.80 $44.41 $305.71 $162.03 $481.44 $255.16 $22.56 $10.60 $25.62 $14.09 $272.00 $127.84 Sunset Quad Quad Quad Aspen Crest Yanaki Sunset Quad V-Rang Fun Fly Aspen Create the following 4 Show Values As PivotTable Calculations in a single PivotTable. Create the PivotTable on a this sheet. 1) Monthly Net Sales 2) Running Total for Net Sales for each month 3) Difference From Previous for Net Sales for each month 4) % Difference From Previous for Net Sales for each month Then add a Slicer for Company. Invoice Number Date Company 659439 1/1/2013 Gel Boomerangs 659440 1/2/2013 Tri Fly 659440 1/2/2013 Gel Boomerangs 659440 1/2/2013 Tri Fly 659441 1/3/2013 Gel Boomerangs 659441 1/3/2013 Gel Boomerangs 659442 1/4/2013 Gel Boomerangs 659443 1/5/2013 Gel Boomerangs 659443 1/5/2013 Gel Boomerangs 659444 1/5/2013 Tri Fly 659444 1/5/2013 Gel Boomerangs 659445 1/5/2013 Gel Boomerangs 659445 1/5/2013 Colorado Boomerangs 659446 1/5/2013 Colorado Boomerangs 659446 1/5/2013 Colorado Boomerangs 659446 1/5/2013 Gel Boomerangs 659446 1/5/2013 Gel Boomerangs 659446 1/5/2013 Gel Boomerangs 659446 1/5/2013 Gel Boomerangs 659447 1/5/2013 Colorado Boomerangs 659447 1/5/2013 Colorado Boomerangs 659448 1/6/2013 Colorado Boomerangs 659449 1/7/2013 Gel Boomerangs 659450 1/8/2013 Gel Boomerangs 659451 1/9/2013 Tri Fly 659451 1/9/2013 Tri Fly 6594521/10/2013 Colorado Boomerangs Product Quad V-Rang Carlota Darnell Quad Carlota Quad Quad Bellen Darnell Bellen Carlota Yanaki Mt. Fun Yanaki Net Sales Cost $616.22 $295.79 $56.40 $26.51 $178.75 $96.53 $391.52 $207.51 $80.24 $43.33 $198.00 $99.00 $396.00 $209.88 $648.00 $336.96 $251.55 $125.78 $393.84 $189.04 $232.48 $118.56 $206.25 $99.00 $57.00 $27.93 $112.08 $56.04 $243.40 $121.70 $529.00 $285.66 $288.00 $135.36 $392.14 $188.23 $672.24 $315.95 $12.12 $6.30 $208.00 $110.24 $83.80 $44.41 $305.71 $162.03 $481.44 $255.16 $22.56 $10.60 $25.62 $14.09 $272.00 $127.84 Sunset Quad Quad Quad Aspen Crest Yanaki Sunset Quad V-Rang Fun Fly Aspen

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: David Ricchiute

7th Edition

0324117760, 978-0324117769

More Books

Students also viewed these Accounting questions