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

Exporting Grouped Data

Sometimes you don't need to export all the raw data that resides in your database. You might need to export only grouped or summarized information, the kind that you might display in a summary report. For example, you might want to list a count of the number of customers in each state, rather than listing all customers. A summarized export is also a great way to “de-duplicate” data. Suppose you want to create a master vendor list from a database that contains every vendor transaction that has ever been. Any one vendor might have several transactions. You want to get a list that shows each vendor only once. For the sake of this example, let's also suppose that you'd like to get a count of the number of transactions for each vendor.

The first step is to create a new summary field called Transaction Count, as shown in Figure 20.6.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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