I'm not sure how to summarize this without showing the data:

For each month, for each client, I have the number of service requests.  I want to be able to look at the distribution (e.g. how many had 1, 2, 3, or 9 requests) for that time period.  By default, I can get this, but it's for each month (like the data) in the attached.

When I change my date filter to represent multiple months, is there a way to get Tableau to re-calculate for each client the number of service requests?  For example, if client abc had 5 requests in January, and 4 requests in February, I want Tableau to mark that as one point with 9 requests, rather than 2 points, one at 5 and another at 4.

My SQL to get the data I want would be like:

select requests, count(*) as clients

from (select client ID, sum(requests) as requests from data_table where month between start_mth and end_mth group by 1) agg_data

group by 1;

Is there a way to get Tableau to re-do that client level calculation over a different date range?

Thank you,

Tim