Pivot table subtotal custom calculations

PPavani · May 12, 2016 2:48AM

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

Thomas Dodds · May 12, 2016 2:09PM

?

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

subtotal is: Revenue*units/sum(revenue)

PPavani · May 13, 2016 2:49AM

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

Thomas Dodds · May 13, 2016 8:43AM

These are two different measures.

cesar.advincula.o · May 13, 2016 9:24AM

Hello,

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

Thomas Dodds · May 13, 2016 10:24AM

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

SriniVEERAVALLI · May 13, 2016 11:55AM

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

Manoj Dixit · May 16, 2016 8:34AM

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

Thank you.

SriniVEERAVALLI · May 16, 2016 9:19AM

use

prodney/Admin123

for that url

Manoj Dixit · May 16, 2016 9:49AM

Hi,

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

Regards.

SriniVEERAVALLI · May 16, 2016 9:51AM

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

Oracle Analytics Cloud and Server