1 of 1 people found this helpful
Please find my workaround attached.
Below is steps I changed to make it happen the way you expected.
1st, add level of detail to each of the worksheet
2nd, modified the action filter as below
3rd, make sure all 3 worksheets set to fit entireview
Hope this helps
Zhouyi, thank you so much!! That was very helpful!!!
Can you explain to me why the level of detail needed to be added to the worksheets? What does that do, exactly?
This is the way I am think pass the value from higher level to lower level and it has to be existed in both sides so that they can match.