Section Access Working to a degree. KPI's showing Correctly but Table Chart showing Information relating to KPI number is BLANK

[simoncarts1990]

I have 2 tables in my Data Model with a Section Access Table applied to the SALES PERSON TABLE linked via the SALESPERSON.TEAM

SECTION ACCESS TABLE

ACCESS

USER.EMAIL

SALESPERSON.TEAM

SALES PERSON TABLE

SALESPERSON.ID

SALESPERSON.NAME

SALESPERSON.TEAM

I have another table with Order Information (SALES TABLE) which links to the SALES PERSON TABLE via the SALESPERSON.ID

SALES TABLE

ORDER.ID

SALESPERSON.ID

Section Access is working in terms of seeing the Sales Numbers via KPI & Bar Charts etc for each Team Managers View but in the Table Chart that lists details on each order (from the SALES TABLE) is blank. This is also the case for the users with Unrestricted access.

What am I doing wrong?

[Qrishna]

a late response, but if you are still looking for solution pls provide some sample data