You can customize sheets to appear or not depending on login.
Use the function Username() to establish conditions.
Ex: calculated filter --> Username()="Luciano"
You can drag more than one sheet into containers, one for each kind of condicion. If you create the calculated filter Username()="Luciano" and use as filter for true condition, other user won't see this sheet.
You need to retire show title and build it on a text.
If you have 100 (for example) users who should see one thing and 100 users who should see something else, you can also break them into groups. Then you can use the ISMEMBEROF() function and knock off 100 users at a time instead of 100 different USERNAME() conditions.
thanks for the answers.
I didnt explain myself well. I want 1 view that will display different data based on the user.
E.g. Each user will only see the products he bought in some sort of graph.
1 of 1 people found this helpful
You'll need the username on your data.
It's just build a calculated field:
Upper(Username()) = Upper([username])
Username() - function that captures who is logged
[username] - your data field
I reccommend use Upper function because is case sensitive.
You drag this calculated field on filters shelf and select the true value.
This looks okay for AD usernames, but does that work when the view is embedded into a non intranet website? and authentication needs to be made based on the website account?