This discussion is archived
0 Replies Latest reply: Dec 11, 2012 10:07 AM by ElMike RSS

Calculate a Column with a % Base of Row

ElMike Newbie
Currently Being Moderated
Hello:

I need help to build a Analytics Report with a column that shows the % based on the value of a specific row, as shown.



CONCEPT BALANCE %
TOTAL SALES 100,814 100%
- NATIONAL SALES 100,814 100%
TOTAL SALES COSTS 7,404 7%
- BUILDING SPENDS 4,872 5%
- MATERIALS 2,532 3%
TOTAL GENERAL SPEND 1,532 2%
- ADMINISTRATION 1,532 2%

As you can see, every value in the third column (%) is a percentage base on the value of the "TOTAL SALES" Row.

I've already try the different options for a "Pivot table", which are Percentage of "Column, Row, Section, Page, Column Parent, Row parent, Layer" when a "Duplicate Layer" of my measure.

Any ideas how to do this?

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points