I have a data set that I want to restrict data displayed based on the user of the dashboard.
Example:
Person
Customer
Amount
Bob
abc
10
Bob
xyz
1
Bob
def
100
John
def
5
John
xyz
10
Jane
abc
1
Jane
xyz
100
If John logs in and he should be able to filter by customer and see the entire sales total.
I.e He can filter on customer def and see total amount of 105 or filter on xyz and see total of 111. John however on the person field should only be able to filter by his name to see the amounts associated with his name and not the other two users.
