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
That's fine. I am waiting for an update from the OP.
With a change to the view, that is, instead of a Pivot - a table view, I could achieve as per a screen dump above.
Group Output = (Sum(Revenue for Year) * Sum(Billed Quantity for Year)) / Sum(Revenue for Year)
Row Output = (Revenue * Billed Quantity) / Sum(Billed Quantity for Year)
A Static Text view explains what the Group Output column values mean. I would try my best to convince the user that due to limitations this could be an option. The values are displayed on the last row per year (similar to 'After' functionality). They could be displayed on the first row (similar to 'Before' functionality).
Edit: Second column has Order Status to check that the group level calculation changes as per the varying row counts per Year values.
Here is a Pivot Table view albiet with a bit different layout. Associated Table view is for verifying the Pivot Table view output.
Hope this helps.
Hello,
Recentlety, I could deal with something like thease in wich SUBTOTAL has a particular calculation, OBIEE make the SUBTOTAL or Total Based on the "Aggretation Rule" that you are using, however, return to your question,what I did it was to create an UNION reports and with the second one I created the SUBTOTAL ROWS that we have to use, lets order by your Column and apply the format that you have to use.
Kind Regards.
Hi,
Right now it's Friday evening so not in front of a computer. But I can fairly guess what you are trying to say.
However, as previously mentioned by Thomas Dodds, those two are different measurements as the calculations are different. Personally, I would keep them separated so that it's less confusing to the users.
Have a great weekend.
Regards,
Manoj.
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
