Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Percentage share based on Grand Total

aPsikusNov 12 2019 — edited Nov 14 2019

We have a report:

# of Workers by 4 dimensions: Region, Month, Age Bucket and Gender presented as Pivot table.

base.JPG

I would like to calculate Percentage share per Gender for each month based on the grand total for each month to present kind of trend change for each month.

calc.JPG

I have tried several options from "Show data as", but none displayed expected results.

Is it possible in OBIEE?

This post has been answered by Jerry Casey on Nov 12 2019
Jump to Answer

Comments