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