Insight (OBIEE) Tips | How to format totals in a pivot table

For more Eloqua Insight Resources, please visit: https://community.oracle.com/topliners/discussion/4470627/eloqua-insight-resource-page

It’s pretty quick to add a pivot table but to format column/ grand totals takes a few additional steps.

Here’s an overview on how to add row/column totals, and format aggregation rules.

For this example I've created an analysis that shows me contacts created by week and their State/Province:

Steps for add/format totals:

1. Once you've added your criteria > Select results > New View > Pivot table (this will add a pivot table below your initial results)
2. Right click on the first column (Contact State/Province