My Oracle Support Banner

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

Last updated on JULY 21, 2023

Applies to:

Oracle Cost Management - Version 12.2.10 and later
Information in this document applies to any platform.


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?



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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