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.
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.
0