Enterprise Command Center Framework - EBS (MOSC)

MOSC Banner

ECC | Display data in matrix format

User requirement: display exact past consumption value of 12 month value for a organization.

We have data set as below for MMT inv:
Item , Trx month , trxnQty

Now user want to view the data as below:
Item, Trx month1 , TrxMonth2, trx Month3

Select item,trxn month,sum(trxqty) from mmt.
here the trxn months should be displayed in the columns , kindly of pivot data.
I understand this can be displayed in chart , but think of the cases where we have so many of Item data , chat will become very tedious to read.

I have tried Grid result but can't achieve this requirement.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center