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

Chapter 17. Setting Up and Establishing ... > Setting Up Date-Driven Lists

Setting Up Date-Driven Lists

Date-driven lists are among the most common types of lists used. All too often people try to combine information related to time in the same column, meaning quarter and date, for example. Never, never do this. If you have to make sense of the data with filters, formulas, or PivotTables down the road, set up your list or data as shown in Figure 17.1.

Figure 17.1. Establish your list with the time periods from biggest to smallest as shown.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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