Pivot Table Data Crunching Case Study Chapter 4

LPAllen

New Member
Joined
Nov 25, 2005
Messages
2
On page 68 of the book, there is a case study for chapter 4, Formatting A Pivot Table:

* How do I create the data item - "Service Plans Sold"?
* Also, as I look at the data for the example in the text - example Great Lakes copier sale, model 2500c it is 611, which appears to be different that the 647 that is in the file that I downloaded. Is that correct?

Thanks!

Larry Allen
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Joined
Feb 8, 2002
Messages
3,140
Office Version
  1. 365
Platform
  1. Windows
Hi Larry,

Thanks for your note. I've uploaded a new file for the Chapter 4 case study. This file includes the Service Plans Sold column.

For the 611 vs. 647 value - the data file is producing a result of 647 in the top left cell of the pivot table. Somehow, the datafile must have been changed to make a point in a later chapter.

Bill Jelen
 

LPAllen

New Member
Joined
Nov 25, 2005
Messages
2
Bill - Thank you for your prompt response. I downloaded the file ptdc1.zip. However, I do not see the Service Plans Sold column. I only see a Line of Business column that contains Service Plans. Please advise. Thanks!

Larry Allen
 
Joined
Feb 8, 2002
Messages
3,140
Office Version
  1. 365
Platform
  1. Windows
Sorry for not being clear. There is a new line item on the download page that indicates it is the datafile for Chapter 4. Download this one.

Bill
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,990
Messages
5,834,761
Members
430,317
Latest member
karenmi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top