O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Creating a Sample PivotTable

Now that we’ve explored the interface, let’s work with a sample in a bit more detail. To do this we’ve first set the PivotTable Field List filter to Internet Sales (measure group). This gives us a more manageable list of items to work with. We’ll look at two measures, Internet Sales Amount and Internet Order Quantity, by selecting them. Selecting these measures adds both of them to our PivotTable display (work) area. It also adds both measures to the Values area.

Next we’ll put some dimensional information on both rows and columns, adding the Customer Geography hierarchy to the rows axis and the Date.Calendar hierarchy to the columns axis as shown in Figure 23-10. Of course, we can also add a filter. We’ll do that next. ...

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