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 -- Customers with Same Last Name in Same City

---

Table of Contents | Next

---

In this example, we want to create a Customer query that will provide totals of all of the customers with the same last name living in the same city.

By adding the result members Customer Number, Default First Name, Default Last Name and Default Address City, 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:

Changing the BI query slightly to remove the customer’s first name and group by the customer’s last name (rather than city), produced the following results: