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,...
Need Help
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            
lbendlin's avatar
lbendlin
Super User
3 years ago

What is your definition of week?

  • learner03's avatar
    learner03
    Post Partisan
    3 years ago

    lbendlin Monday to Sunday, So week end day will be Sunday.

      • learner03's avatar
        learner03
        Post Partisan
        3 years ago

        lbendlin Thanks. I saw your solution. But, as you have used 2 seperate visuals, I want in one visual, so that when user exports the data, it should all get expored at once.