How to limit the values showed without altering values?

Hi,

We have some scenarios when we need to calculate some metrics based on all the history. For example, contribution and more. We need to include several data to get the right value. But, for example, if we have an history of 5 years, we need to perform some calculations on the whole data, but the user wants to see only the last year information. But this information is calculated by taking all the history. If I apply a filter, I'm able to see current year data, but the values are not correct, because I need all the history (for example, churn rate history). Is there a way to perform that in the widget?

Thanks!