I have a data table in a sharepoint list. It contains three columns: 1) Name 2) Date 3) Quantity of fruit purchased
I want to sum the quanity of fruit purchased by each person in a given given week. i would then want to display it like the following. Whats the best way to do it?
| | January | January | January | January |
| | Week 1 (1st- 7th) | Week 2 (8th-14th) | Week 3 (15-21) | Week 4 (22-29th) |
| Person A | 100,000 | 0 | 3 | 0 |
| Person B | 0 | 2 | 400,000 | 0 |
| Person C | 5,000 | 0 | 1 | 0 |
| | Feb | Feb | Feb | Feb |
| | Week 1 (30th Jan- 5th) | Week 2 (8th-14th) | Week 3 (15-21) | Week 4 (22-29th) |
| Person A | 100,000 | 0 | 3 | 0 |
| Person B | 0 | 2 | 400,000 | 0 |
| Person C | 5,000 | 0 | 1 | 0 |
So on and so forth.
I have a Matrix table that show by year, quater, month and date. But I would need standalone tables that can disolay it like above.
