Double dynamic segmentation

Hi everybody,

I'm preparing a report with a double dynamic segmentation that doesn't work, so I ask your help.

I've got a table with dates, locations and number de events, similar to:

And in the report I have 2 data segmentations, () one for "dates" and the other for sum of "number of events". The limits of this one (sum of "number of events") must be between the allowed possibilities according to the date segmentation.

With the one for "dates", obviously, I filter the dates, and with the one for "number of events", I want to retrieve the locations whose sum of events in the filtered period are between the marked limits and the sum of their events.

Examples:

A) if I select in date segmentation:

Then, the sum of "number of events" segmentation must be:

If, in this case, I don't move the "number of events" segmentation, the result must be:

But, if I select:

I must get the locations whose sum of events in this period are between 7 and 13: 

B) If the date segmentation is:

Then, the sum of "number of events" segmentation must be (please, notice that now it's between 2 and 8, due to the number of events it's something dynamic in the original data):

So, in this case, the result must be:

And, if I move the maximum from the sum of "number of events":

The result must be:

Can someone help me to solve this issue?

Thanks in advance.

Best regards!