Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Go with section access to filter the data
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