• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Working with PivotTable and ... > Creating the Query for a Sample Pivo...

Creating the Query for a Sample PivotTable View

Queries designed for users who are accustomed to using Excel PivotTable should offer a high degree of flexibility for slicing and dicing the data. For example, sales and marketing managers are likely to want to explore the total value of orders received each quarter by salesperson, customer, product, country, or any combination of these selection criteria. Thus, your query must supply more than the ordinary amount of data to the PivotTable.

One of the most common forms of PivotTables displays time-series data, such as orders or sales by quarter for one or more years. To design a time-series query that supplies the underlying data for a PivotTable to display the quarterly value of orders by salesperson and country, do the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint