Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have got a problem. I have a section access and 2 sheets.
My section access :
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, AFRICA
USER, USER2, U2, AMERICA
USER, USER3, U3, ASIA
USER, USER4, U4, EUROPE
USER, USER5, U4, AMERICA
USER, USER5, U5, *
];
Section Application;
SALES:
LOAD * INLINE [
REGION, PROFIT
AFRICA, 1000
AMERICA, 2000
ASIA, 3000
EUROPE, 4000
OCEANIA, 5000
];
In my sheet 1, USERS can see only data from their Region.
And in my Sheet 2 (only 2 charts), I want that my USERS see all data ALL REGION. Just for a data comparaison.
Is it possible to unhide the data just for one sheet ?
Thanks a lot
Hi.
I think you could load all regions separately aggregated:
TotalSales:
LOAD
'ALL REGION' as REGION,
Sum(PROFIT) as TotalProfit
RESIDENT SALES
GROUP BY 'ALL REGION';
And then use 'ALL REGION' in section access.
Like this ?
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION, ALL REGION
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, AFRICA, YES
USER, USER2, U2, AMERICA, YES
USER, USER3, U3, ASIA, YES
USER, USER4, U4, EUROPE, YES
USER, USER5, U4, AMERICA, YES
USER, USER5, U5, *, YES
];
As you can see I've loaded the value 'ALL REGION' in field named REGION, so no, not like this.
Ok thanks I wil try your method !