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
  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi chinma 

    Please add warehouse in row header before ID 
    Please find the pbix link 

    If your requirement is solved, Please mark as SOLUTION

    Thanks
    Pijush

    • chinma's avatar
      chinma
      Frequent Visitor
      2 years ago

      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.