0

Adding a column in the pivot table both as amount and percentge of total

Jet Reports Historic Posts

July 05, 2017 14:16

None

Follow

Using a cube, I have created a pivot table with 2 levels of columns.
I have the amounts shown (and I want that) but I want to add a column that contains the second level as a precentage of the first.
Is there a measure needed to do that?
Or can that be done in the pivot table?

If so, how?

Thanks in advance.

rmw

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 05, 2017 23:16

  You mean something like this?
  
  http://www.excelchamp.net/how-to-show-values-percentages-in-excel-pivot-tables/

• 0
  
  Jet Reports Historic Posts July 10, 2017 07:16

  Something like that yes :)
  Thanks.
  
  Little bit of fidling still needed, because I have 2 levels of columns and adding the amount again to the pivot table gives me a percentage on every level.
  I only need it on 1 of the 2.
  But this is a major step in the right direction.
  
  rmw