Categories
Pivot table subtotal custom calculations

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
Answers
-
?
each row is: Revenue*units/sum(units)
subtotal is: Revenue*units/sum(revenue)
0 -
Yes. Subtotal calculation should be some other calculation but not same as row calculation
0 -
These are two different measures.
0 -
Hello,
Setup your Aggregation Rule, in your Pivot Measure, as a "Server Complex Aggregate"
0 -
Cesar ... the request is for a different calculation formula on the subtotal row than what is on the detail rows ...
0 -
I think this is what we can get at most!!
0 -
Has this been resolved now? Sorry I can't access the above URL. Please update.
Thank you.
0 -
use
prodney/Admin123
for that url
0 -
Hi,
I mean due to security I can't access the environment. Sorry for the confusion caused.
Regards.
0 -
above url is from Oracle, I dont know about your security but this is open access for all.
0