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
?
each row is: Revenue*units/sum(units)
subtotal is: Revenue*units/sum(revenue)
Yes. Subtotal calculation should be some other calculation but not same as row calculation
These are two different measures.
Hello,
Setup your Aggregation Rule, in your Pivot Measure, as a "Server Complex Aggregate"
Cesar ... the request is for a different calculation formula on the subtotal row than what is on the detail rows ...
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!!
Has this been resolved now? Sorry I can't access the above URL. Please update.
Thank you.
use
prodney/Admin123
for that url
Hi,
I mean due to security I can't access the environment. Sorry for the confusion caused.
Regards.
above url is from Oracle, I dont know about your security but this is open access for all.
Hello Oracle Analytics Community, We are investigating a dashboard compatibility issue between Oracle Analytics Server (OAS) 7.6 and OAS 7.0. Some dashboards originally created in Oracle BI 12c can be opened in OAS 7.6 but fail to open after being archived and imported into OAS 7.0. During our investigation, we found the…
Hi all, We’re running into an issue with an on-premises Oracle Analytics Server 2026 integrated with Active Directory and hoping someone has seen this or knows if a patch is available. Environment: Oracle Analytics Server 2026 (on-premises) WebLogic 14.1.2.0.0, JDK 21, Oracle Linux DB-backed catalog (Oracle DB, BIPLATFORM…
We have a requirement Creating a Bar graph using Cost Center Tree hierarchy as prompt/filter. Created a Bar Graph using Cost Center Tree Hierarchy as a prompt. When I'm selecting values through selection steps from Cost Center Tree Hierarchy, the Bar Graph not refreshing as the selected values are not passing to Graph…
I have 2 tabs on the workbook that use the same dataset. I would rather not use 2 different datasets. Can I code an expression filter or something to remove those records?
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4