nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Pivot Table -Calculating %s

35e30d56-c405-410d-bd98-fffeb55cc7bf

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?

Find more posts tagged with

Accepted answers

All comments

Shams Abbasi

You mean you want to create two more columns

1. S&T/MM

2. EDS/MM

is that correct?

35e30d56-c405-410d-bd98-fffeb55cc7bf

Yes, exactly.

35e30d56-c405-410d-bd98-fffeb55cc7bf

I've tried a couple of different ways, but the pivot table just ends up with blanks where the results should be.

[Deleted User]

Looks like "%" is your measure but "MM", "S&T" and "EDS" are actually members inside an dimensional attribute, correct?

35e30d56-c405-410d-bd98-fffeb55cc7bf

Yes

[Deleted User]

Normally you modify members by the use of "Calculated Items":

35e30d56-c405-410d-bd98-fffeb55cc7bf

Christian, But how do I do that. I cannot created a formula that works for both columns.

[Deleted User]

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.