Forum Discussion

learner03's avatar
learner03
Post Partisan
3 years ago

Matrix view with weekend going across

I have this below table-

I need to have the view as matrix or table with summarised by Category,column with Stock on hand, committed and then based on the weekend date of the Stock due date, i need the weekend going across with the values of Due Qty feeding in as per weekend.

 

After that when you drill through any category, we are directed with same view but product id and subcategory-wise.

bolfri  amitchandak 

Need Help

7 Replies

    • learner03's avatar
      learner03
      Post Partisan
      3 years ago

      lbendlin 

      The input table-

      Product ID category Sub category StockDue Date Due QTY On Hand Committed
                   
      1 Bed bedsheet 1/03/2023 20 19 21
      2 Pillow Pillowcover 8/03/2023 42 23 32
      3 Quilt Qcover 16/03/2023 35 54 43
      4 Towel Pool 2/03/2023 43 65 65
      5 Bed Bedsheet 22/03/2023 24 23 76
      6 Pillow Pilprotector 1/03/2023 34 45 87
      7 Quilt Qdouble 15/03/2023 65 43 45
      8 Towel Mat 6/03/2023 76 23 34
      9 Bed bedsheet 24/03/2023 34 45 54
      10 Pillow Pillowcover 9/03/2023 56 65 23
      11 Quilt Qcover 8/03/2023 54 23 54
      12 Towel Beach 20/03/2023 34 12 34
      13 Bed bedcover 1/03/2023 23 4 76
      14 Pillow Pilprotector 27/03/2023 54 54 44
      15 Quilt Qsingle 9/03/2023 65 555 34
      16 Towel Pool 10/03/2023 76 43 23
      17 Bed bedcover 8/03/2023 76 564 54
      18 Pillow Pillowcover 12/03/2023 35 35 65
      19 Quilt Qking 21/03/2023 47 654 76
      20 Towel Beach 12/03/2023 56 345 87

       

      Output format-

            Weend end date/Stock Due
        Sum of On Hand Sum of committed 4/03/2023 11/03/2023 18/03/2023 25/03/2023
      Bed            
      Pillow            
      Quilt            
      Towel