Hello,
I need some help to implement an idea.
I have, in data verse a table called Products where I have all my products available for buying. When a customer came and buy something I will record the location, quantity and product name.
I need to create in Model Driven app, a view where I have something like this:
| Location | Book | Pen | Sponge | Top paper | Tape |
| Bucuresti | 0 | 3 | 12 | 4 | 2 |
| Urziceni 1 | 1 | 12 | 0 | 2 | 1 |
| Ploiesti | 3 | 4 | 0 | 0 | 4 |
The idea is that the headers will be with all the products name and in the lines for each location I will need to have the quantity filled. For example: in Bucharest there will be 3 pcs of Pen, 12 pcs of Sponge and where I have no quantity It will be by default 0.
Do you have any idea how can I do this?
Thank you!
