I have a fixed Number of hours(8) multiplied by the number of distinct days a user has worked.
What I want?
I need this number as text to insert into a title on a dashboard.
However, I need to separate this number by the User filter from another worksheet. When I apply this, I just get the total number of distinct days (not per user).
This is what I have done so far in the calculated field: