O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3. Why Wouldn’t I Build Every Future Pivot Table in PowerPivot?

I am going to ask you to step into the WayBack machine.

Do you remember at the end of Chapter 2, “The Promise of PowerPivot,” somewhere around Figures 2.33 through Figures 2.37, where I showed you how to take a regular Excel data set through PowerPivot to enable the ability to use named sets to create asymmetric reports? When I realized that PowerPivot allowed me to create those types of reports, I asked the question, “Well then, why wouldn’t I build every future pivot table in PowerPivot?” By the end of this chapter, you will understand why you might not want to do that.

Now, let ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required