Forum Discussion

chinma's avatar
chinma
Frequent Visitor
2 years ago

Matrix with Multiple Group

Dear Team,

I have a table with values for Date,WarehouseID,TotalInvoice,TotalUnAllocated,UnAllocatedSafetyStock,UnAllocatedRAW, (TotalUnAllocated-UnAllocatedSafetyStock-UnAllocatedRAW) as UnAllocated_Less_RM_SS. I need to create a matrix with Date as Column and (TotalInvoice,TotalUnAllocated,UnAllocatedSafetyStock,UnAllocatedRAW,UnAllocated_Less_RM_SS) as Rows for each WarhouseIDs. Also I need to have GrandTotal for all warehouses for each date at the bottom of matrix.

Here is the sample data:

Expected Result:

 

Any help would be appreciated greatly.

Thanks in advance.

 

9 Replies