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 UnAllocate...
Need Help
Show and Tell
chinma's avatar
chinma
Frequent Visitor
2 years ago

PijushRoy My requirement was to have detail section for Total as well.  It should be the sum of Total_Un_Allocated, Sum of Total Invoice....etc for all the warehouse IDs for each day.

eg:

Please let me know how to achieve this.

Thank you.

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi chinma 

    As per my idea, you can combine two tables to achieve this

     

    If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

    Thanks
    Pijush