Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Displaying The Value Of An Account Broken Down By Dimension As A Percent Of The Total Value Of The Account

Question

I have a report that breaks down a Cube account by dimension. I would like to add a column that displays the value of the account broken down by dimension as a % of the total value of the account. How can I do this?

Answer

This can be done using a Display As % element.  In order for the column to show the % of the account by dimension based on the total value of that account, you must first create an Assumption account that references the value of the Cube account. The purpose of this is to remove dimensionality from the account. Once this Assumption has been created, you can set the Display as % element to display the values as a percent of the Assumption account.

  • Was this article helpful?