Forum Discussion
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
- chinmaFrequent Visitor
PijushRoy Here is the link for sample data https://drive.google.com/file/d/1wfomYish9U5AVZzcqUxYKVzal-CFAgYO/view?usp=sharing
Thank you.
- PijushRoyCommunity Champion
- chinmaFrequent Visitor
PijushRoy Thank you for the quick response. But my request is "On expanding" each warehouse ID, it should show the rows for " Total Invoice,Total Un Allocated, UnAllocated Safety Stock,UnAllocated RAW material, UnAllocated_Less_RM_SS)
same as given below:
Also it should show the Total as "ALL Locations" with details in rows.
eg:
Let me know if you have any solution on this.
Thank you.