Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to calculate the percentage of specific category value out of the grand total?

Accepted answer
392
Views
2
Comments
JobDeLuna
JobDeLuna Rank 5 - Community Champion
edited Aug 13, 2024 7:39PM in Oracle Fusion AI Data Platform Forum

Hello,

Any idea on how to calculate the percentage of a specific category value out of the grand total?

My goal is to create a tile visualization for each fiscal quarter so I need to have separate calculation for each quarter?

I'm

Thank you!


base.PNG


Tagged:

Best Answer

  • JoseP-Oracle
    JoseP-Oracle Rank 3 - Community Apprentice
    Answer ✓

    @JobDeLuna - If you want just to display the Base Plan Spend as a percentage instead of the value amount as in the report you provided, you just add the Base Plan Spend metric twice to the DV visualization, the go to Properties -> Values, chose one of Base Plan Spend column to display as Percentage and change its Display As property from Values to Percentage Of: All Values.

    If what you want is to have a separated calculated column for the the percentage of an specific month (i.e. FYQ1, then create a calculated formula with a formula as below.

    filter("Base Line Spend" using "Fiscal Quater" = 'FYQ1') / "Base Line Spend"


Answers