I have a User Table where i setup each role. Those roles are used as criteria in the Show If formula of my views.
My formula is :
ANY(sCurrentUser[Role2])<>"NA")
where the slice "sCurrentUser" has a criteria of [UserEmail]=USEREMAIL()
The ANY () formula above works when the view type is Table, Deck, Form etc, but does not work for Chart View.
Any explanation on this issue would be helpful.
Thank you.
User | Count |
---|---|
17 | |
11 | |
7 | |
4 | |
3 |