Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Pivot Table - Percent of Grand Totals

Question
3
Views
0
Comments
1ac9a955-176a-4bfa-a765-e06b3e016706
1ac9a955-176a-4bfa-a765-e06b3e016706 Rank 1 - Community Starter

Quick question, when in a pivot table and you turn on Row Totals and Column Totals I thought there was an easy way to also get a percent of the Total Row and/or Total Columns?

Its been awhile since I was developing in OBIEE but I couldn't do it without duplicating the layer and then changing the values to Percent of. But then I can't hide the details or anything so I'm stuck with the individual percentages which essentially doubles the width of the report. Thought t I remembered a way where you just needed to finagle some of the settings and layer totals but maybe I'm thinking of something else.

Thanks, cheers.