Hi All,
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.
What would be the best approach?
