4 Replies Latest reply: Oct 23, 2012 5:22 AM by Bertrand Couthenx RSS

    Unhide Data in one Sheet

    Bertrand Couthenx

      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