Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Display as a Percent of Total

The following report shows the revenue amount and the percent of revenue to total revenue for Levels:

Display As column rows can't have the % sign.  In the example below, the column heading was renamed to %.

clipboard_edd958cf4580e005e9c547c5ae929becc.png

Steps to Create the Following Report:

  1. Add Levels to the rows.
  2. Add Time to the report columns and as a Parameter to make the report more dynamic.
  3. Open Display As from the Element’s list and add Value and Custom (renamed as % below) as columns in the report (See below for further instruction).
  4. Right click on Custom and select Formula Assistant and add a formula (See below for further instruction).

clipboard_e00d2bfe2764a318b0fe64361c4bc3c82.png

How to add Display as Custom Element:

In the report builder, select Display As from the Elements list and add Value and Custom to the report:

clipboard_e3625eda032f43ad29ba5069f7cc9b9a3.png

Right-click on Custom and select Formula Assistant:

clipboard_e6037d4a5a8fd0e10dcf1e72fa4a1ee02.png

Add a formula like the one below to calculate the percent as a total:
(ACCT.this/ACCT.this[level=United States(+)])*100


  • Was this article helpful?