Please see the attached
it returns this
the calculations are
I put in a parameter ( your user will see it looks like the filter you had in your viz) (note the Year dimension in your data is not a date it is a number so the parameter is an integer)
Then I added the filter
if you don't want to see the py data just hide it
and this is what you see
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Employees_v10.2.twbx 15.3 KB
Thank you for your response,This was very helpful!
That sounds good.