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.

    • 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.