Section Access : Combining Field Reduction and OMIT

[Jacob]

Hi All

I have below Requirement in section access.

Requirement 

*       i have User1  and User2
      User1 

*       can see 2 countries data out of 15 countries i.e IND and US
*       User1 can see the US of COGS, but cannot see the India COGS
User2

*      Can See all the all data

Please refer below table 

Country 

Country	Product	Region	info
IND	BOOK	E	ABC
UAE	PEN	W	XYZ
US	BAG	N	XYZ
UK	PHONE	C	XHD
PAK	LONG BOOK	E	XJZ

Sales  

COGS	SALES
100	10
200	20
300	30
400	40
500	50

.

Output

When User1 login he should see below table

Country	Product	Region	info	COGS	SALES
IND	BOOK	E	ABC		10
UAE	PEN	W	XYZ	200	20

When User2 login he should see below table

Country	Product	Region	info	COGS	SALES
IND	BOOK	E	ABC	100	10
UAE	PEN	W	XYZ	200	20
US	BAG	N	XYZ	300	30
UK	PHONE	C	XHD	400	40
PAK	LONG BOOK	E	XJZ	500	50

[rubenmarin]

Maybe there is a better way of doing this but I get similar result splitting Sales and COGS in diffrent tables and duplicate rowes in the country table to have a row for Sales and another for COGS.

This way you can set different permissions for sales and/or cogs

PFA, set your domanin user in section access and enable 'reduce data on open' to test.

[Jacob]

Can't open the QVW file can u please comment section access code.

[rubenmarin]

Attached with section access commented