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

Troubleshooting

Enabling Drilldown

Q1:Why can't I drill down in my PivotTable?
A1: To be able to drill down by double-clicking, the Enable Drilldown option must be selected in the Data Options section of the PivotTable Options dialog box.

Grouping PivotTable Dates

Q1:How do I group PivotTable dates?
A1: Select the first date cell in the PivotTable; then choose Data, Group and Outline, Group. Enter the Starting At and Ending At date. Select the time measurement under By, and adjust the Number of Days setting if necessary.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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