0

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

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

2 comments

Please sign in to leave a comment.