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 subtotal custom calculations

PPavani

hi Gurus,

Can we write the custom formula for the Subtotal (Highlighted field) area. which should be Revenue*units/sum(revenue) like this.

It can be any formula.

Please let me know if any possibility.

Thank you!

Pavani

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

each row is: Revenue*units/sum(units)

subtotal is: Revenue*units/sum(revenue)

PPavani

Yes. Subtotal calculation should be some other calculation but not same as row calculation

Thomas Dodds

These are two different measures.

cesar.advincula.o

Hello,

Setup your Aggregation Rule, in your Pivot Measure, as a "Server Complex Aggregate"

Thomas Dodds

Cesar ... the request is for a different calculation formula on the subtotal row than what is on the detail rows ...

SriniVEERAVALLI

Check this http://slc02ojq.oracle.com:7780/analytics/saw.dll?PortalGo&Action=prompt&path=%2Fusers%2Fprodney%2FPavani

I think this is what we can get at most!!

Manoj Dixit

Has this been resolved now? Sorry I can't access the above URL. Please update.

Thank you.

SriniVEERAVALLI

use

prodney/Admin123

for that url

Manoj Dixit

Hi,

I mean due to security I can't access the environment. Sorry for the confusion caused.

Regards.

SriniVEERAVALLI

above url is from Oracle, I dont know about your security but this is open access for all.