AudienceView Connect

Example Pivot Extract -- Sales by Postal Code


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:

Name Srt/Grp/Tot Function Heading Display Type Order
Performance Code Ascending Grouped     Vertical 1
Postal Code       Horizontal 2
Order Number
(Prior to AudienceView 6.8.11)
Sub and Side Totals Count   Data 3
Order Number
(as of AudienceView 6.8.11)
Sub-Totals Count   Data with Side-Totals 3

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