1 of 1 people found this helpful
Since you can't show a workbook I can only give you a conceptual answer
Place your date on the filter shelf and set to context - that will lock in the data for the period - the you can apply a filter without affecting the calculation
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.