I want to have a graph that shows the total value of a user/department v's everyone. I have created two tables; one that includes the field that security is applied to and another that excludes this field, i.e
Department (data security applied)
I was hoping to create a graph with the date as the category, and then the values are:
Column 1 =Table 1 Total (just the users department)
Column 2 = Table 2 Total (all users)
Is there a way to do this? I have tried merging on date, but of course, row level security is applied.
Many thanks in advance,
Please sign in to leave a comment.