Oracle Transactional Business Intelligence Idea Lab

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

Add custom calculation while generating Pivot table in BI using custom DM

41
Views
3
Comments

Description

Does anyone know how to create % of Grand Total or % of row total during pivot table generation using custom DM (just like pivot options in Excel)? I only see count, count distinct enabled and the rest of aggregation options are grayed out. 

Use Case and Business Need

We need to display the % of the row total and grand total

Original Idea Number: 570d00b3c5

1
1 votes

Submitted · Last Updated

Comments