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

Chapter 6. Importing Data: Further Consi... > Preparing Data for Pivot Tables

Preparing Data for Pivot Tables

There are some special considerations to keep in mind when you specify the records you want to use in pivot tables. These issues don't apply to external data ranges unless you then use the external data range as the source for a pivot table. The idea is to avoid putting records into the pivot table if they contain null values in a field that you want to use to group records.

Grouping on Date and Time Fields

It often happens that you want to analyze data in a pivot table using a date or time of day as a row, column, or page field. For example, you might want to know the average number of traffic accidents during each hour of the day or during each day of the week.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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