Section Access on Two Fields

[waleeed_mahmood]

Hi all,

I have two tables. One is a regional level table and other is a rep level table. So basically, the regional level table has no rep data to it at all. But the rep level table has region assigned to each row.

now i have two sheets in my app, one that shows regional numbers and one sheet that shows rep level numbers.

what i want is the following:

if a rep logs in the app:

1. in the rep sheet, he only sees his numbers.

2. in the regional sheet, he sees his entire region.

so if Rep A belong to Eastern Canada, he should only see Eastern Canada's regional numbers as well as Rep A's numbers.

How can i achieve this with section access? 

@hic if you be so kind to suggest something, i'd really appreciate it.

[hic]

If you have two tables, one with rep data and one with region data, this should work straight away.

Just create a Section access with Rep as reducing field, and you will get exactly what you want.

Note that you will then calculate the Region sales from the region table. You cannot use the [Rep Sales] field and accumulate this to region level.

HIC

[waleeed_mahmood]

Hello HIC,

Thank you for your input.

I am unable to get both views working at the same time. I have the following data model:

I have a few fields that are similar between the Rep Table(RepActuals) and the Regional Table (FINAL) so naturally i have a synthetic key. Then i have the following in my section access script :

SECTION ACCESS;
[ACCESSTABLE]:
LOAD
    "ACCESS",//USER or ADMIN
    "USERID",//AD001\SALINK
    SALINK//this reduction field is the userID of a Rep
FROM ....
SECTION APPLICATION;
[LINKTABLE]:
LOAD
    SALINK,
    GID //this field exists in the Rep Actual Table and is the ID of a Rep 
FROM....

But in this way, i only see the numbers at Rep level and not at Regional level. Could you point out as where i might be going wrong at this?

Thank you.