Filters are specific to worksheets unless you apply or pass them from one sheet to another
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.
Without seeing your work and trying to interpret your writing, I would say that in addition to Jim's suggestion you will need a fixed calculation for the second part of your question. If you could share a sample of your work it would be so much easier for people on the forum to assist you.