I have the following scenario. I am trying to apply the brushing technique (highlight not filter) and came to following problem.
I have one diagram with Month as dimension(Chart1) and another one just below with Weeks als dimension (Chart 2). Both share the same expressions.
The problem comes because one Week can belong to 2 months.
In my calculation I want to display only the No. of Rounds related to the selected month (like in Chart 3) but still show all the weeks.
In the case above, Chart 2 should show 4 and 1.
Is this possible at all?