Insight | How to Add Percent of Grand Total

For more information and tips visit the Eloqua Insight Resource page.

Is there a way to show the column percent of grand total?

Yes, you will need to add a column to your report with a Calculated Measure, along with some minor column formatting, below are the steps.

Use case: I have a report where I see total contacts created by month. Within this report  I want to see what the percent of total contacts was created in each month.

Steps:

1. Within the results tab select New Calculated Measure

2. Add Custom Headings (folder and column heading)

3. Add the following Column Formula