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.