I would like to know how to do subtotals in a pivot table (see picture attached)
J’aimerais savoir comment faire des sous-totaux dans un tableau croisé dynamique
(voir l’image en pièce jointe)
If you don't have something making those splits (like a column attribute) you will need to add calculated items defining by hand what should be inside.
If your dimension is well defined for the business need, it will be a one-click action of adding totals on that column.
J’ai créé un élément calculé
J’aimerais que le sous-total s’affiche par « Mode de sollicitation contrat publié » sur la ligne horizontale
Est-ce que c’est possible ?
Voici mon élément calculé :
CAST(SUM(« Fait - Contrat publié ». » Valeur contrat » BY « Type contrat (contrat publié) ». » Mode de sollicitation contrat publié ») AS DOUBLE)
Bonjour,
J’aimerais savoir si quelqu’un peut m’aider avec une formule pour faire un sous-total.
J’en aurai vraiment besoin.
Merci.
I would like to know if someone can help me with a formula to make a subtotal. I will really need it. Thanks.
It's just there on your column "Mode de sollicitation contrat publié", click the total icon and select the position where you want it.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (ERP). The session will cover updates on Finance, Projects, and Procurement. Presented by: Ashlesh Bajpai - Vice President, Product Management, Fusion Data Intelligence Shobana…
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?
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
