Hi All,
I have a scenario that I need to implement using section Access:
My data contains the following:
| Key |
Vendor |
Sales Amount |
Units |
| 1 |
ABC |
20 |
2 |
| 2 |
XYZ |
100 |
50 |
| 3 |
KLM |
50 |
20 |
I have a User-Vendor mapping:
| User |
Vendor |
| mno.1 |
ABC |
| ijk.1 |
XYZ |
When a user, for example, 'mno.1' logs in, application shows the below:
- His own vendor's entire data.
- Complete data for other vendor data for a certain column but 0 for the rest.
In our case, it should finally show:
Sum of Units = 2+50+20=72
Sum of Sales Amount = 20+0+0=20
Is this achievable? Please help
Thanks in advance.
