Section Access to show partial data

[mansi_dv]

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.