filter changing accordingly to the user connecting...

[ovonel]

I have a page-filter where I have username and I have it with the “require single selection”

But, whenever each user logs to the report it sees username=Alan, because I published it with that filter fixed…. Is there a way I can change it so that whenever each user logs sees her/his own filter?

That is the filter should change based on who access it... How can I achieve it?

[ovonel]

I already have that in place... but that's not what I am looking for...

For example we have the case of super-user who has access to multiple users; even in that case, I want the super-user to see by default herself/himself...

For example for 'current month' is easy because I can create a calculated column... but USERNAME() is not allowed in calculated columns...

[amitchandak]

@ovonel , You can use RLS

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk