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  Thank you for your solution . Its almost worked except that I need to have expandable section for Total at the bottm of the matrix as " All locations" for sum of each attributes with details as shown below:

 

 

Any help would be grateful.

Thank you.

 

  • 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