two separate filter for same application

[Anonymous]

I have two users one can view sales chart other can view purchase chart.

How can i do this ?

is it the right approach to make it indirect set analysis?

if user A logged in then he can able to see-sales chart

if user B logged in then he can able to see-purchase chart

[sivarajs]

Go with section access to filter the data

[#3]

Hi ,
Yes u can try This

Create a security table

Please find below tables ;

Example

Table:
Load

User Name  SHEET1  SHEET2  
*                    1             1

User1             1             0

User2             0             1

Left join

Load
ACCESS  USERID   PASSWORD UserName  Group           SheetView       
ADMIN   qvadmin    123                  *               ADMIN             *
USER   *                 *                   User1          Sales         SHEET1              
USER   *                 *                    User2         Purchase   SHEET2     

Sheet 1  for view Sales chart.

Sheet 2  for view purchase chart.

Hope above Table will work.

Regards-Bika