Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Pivot Table - Percent of Grand Totals

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.