Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Percentage share based on Grand Total
We have a report:
# of Workers by 4 dimensions: Region, Month, Age Bucket and Gender presented as Pivot table.
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.
I have tried several options from "Show data as", but none displayed expected results.
Is it possible in OBIEE?
Answers
-
I'm not sure why none of the "show data as" options didn't work, but you can do it by creating a 3 "New Calculated Items" on Gender.
The calc would be 100*'Female'/('Female'+'Male'+'Not Declared'), with the same for the other genders.
Then, go into the Gender column properties and create a conditional data format for when Gender IS NULL. Make it percentage, with however many decimal places you want.EDIT: Sorry, I skimmed too quickly. The above gets you gender pct by age bin at all subtotal and grand total levels. It looks like you need a calculated column
along the lines of 100*SUM(Workers by Region, Month, Age Bucket and Gender)/SUM(Workers by Month)0 -
Jerry,
You're DA MAN!!!
Just one correction to the proposed formula:
Using: 100*SUM(Workers by Region, Month, Age Bucket and Gender)/SUM(Workers by Month) calculates same percentage in all rows.
After small correction: 100 * Workers / SUM (Workers by Month) calculates as required.
Many thanx!
0
