Your question is not clear. Can you please try to explain in detail..?
Thank you for looking at it.
Sorry for not being clear. There is a list of sources on the right side that are made into action filters. If you scroll over Federal (for example), the two sheets should filter.
Notice that the action filter works on one of them and fails on the other. I'm assuming that this is due to a data blending I used...
(Note that this is part of a much larger dashboard and data blending has to be used.)
Let me know if you have any other questions about this.
I think that the issue is that the Action Filter requires a field that might not be present in the sheet since it's blended data..
I think you may just need to add another entry to the Dashboard Action Selected field
where SourceField=Major Category and Target Field=MajorFundCategory from Actual.
I didn't check the numbers carefully, but the value was modifying on hover.
Please see workbook attached in the Forum thread.
270059hover.twbx 35.1 KB
Thank you so much!