How to show the difference between two columns in ECC Aggregated table? (Doc ID 2952324.1)

Last updated on JULY 21, 2023

Applies to:

Goal

Prepared aggregated table by using Margin Summary data, then grouping data by product and  fiscal year.

It provides the summary of data based on every fiscal year.


 Need to see the difference between successive year for the field
"Gross Margin Percentage" .( i.e. How much value changed between 2022 to 2023
for the field “Gross Margin Percentage").

Steps to reproduce :
a. Go to the Cost Management Responsibility. Drill down and click on Command Center.
b. Click on Margin Analysis dashboard/
c. Under products tab,  created an aggregated table using margin
    summary data set.  grouping data by product and fiscal year.
d. And selected Gross Margin, Margin percentage as Metric columns.
e. Show the change (difference) between Margin percentage between
    two fiscal years, there it is showing Sum, need to show the difference. How to achieve that?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.