AudienceView Documentation

• Adding New Result Members to a BI Query
• Sorting, Grouping or Totalling Result Members
• Sorting Results by Data Not Included as a Result Member
• Defining an Aggregate Function
• Creating a Pivot Extract (Display Types)
  • Example Pivot Extract -- Customers with Same Last Name in Same City
  • Example Pivot Extract -- Sales by Postal Code
• Deleting Result Members

Product Guides > 6.3.0 Product Documentation > 6.3.0 Application Documentation > AudienceView User Guides > Business Intelligence and Reports Guide > Business Intelligence and Reports Business Intelligence > Using Business Intelligence > Working with Result Members > Creating a Pivot Extract (Display Types) > Example Pivot Extract -- Sales by Postal Code

---

Table of Contents | Previous

---

In this example, we want to create an Order query that will provide totals sales by performance by postal code.

By adding the result members Order Number, Postal Code and Performance Code, the following image illustrates the preview of the resulting data.

Here is how the BI query is configured:

Based on this customer data and the BI query illustrated, the following image illustrates the query results: