Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Pivot Table -Calculating %s
I have the following pivot table created in my report. The column MM represents base sales, and the 'S&T' and 'EDS' columns represent additional software sales to go with the base.
What I need to do is create calclulations for 'S&T' / 'MM" and 'EDS' / 'MM'. I cannot figure this out. Can anyone help?
Answers
-
You mean you want to create two more columns
1. S&T/MM
2. EDS/MM
is that correct?
0 -
Yes, exactly.
0 -
I've tried a couple of different ways, but the pivot table just ends up with blanks where the results should be.
0 -
Looks like "%" is your measure but "MM", "S&T" and "EDS" are actually members inside an dimensional attribute, correct?
0 -
Yes
0 -
Normally you modify members by the use of "Calculated Items":
0 -
Christian, But how do I do that. I cannot created a formula that works for both columns.
0 -
Oh you're on 10g?! No clue if that even existed back then and haven't touched that version in over 6 years. Maybe time to upgrade to something a bit less unsupported.
0