You can use calculated fields to separate the logic for “Sales” and “Lifetime Sales” while applying filters only to the “Sales” column.
Use a formula that ignores date filters. You can achieve this by using a Level Aware Calculation (LAC), which uses the sumOver() function. The sales column can remain unchanged and will be affected by the date filter.
Example : (Syntax may vary)
sumOver(Sales, [Player])
Please refer the below documentation this might be helpful for you.