without seeing your data and sample workbook, I guess you applied add to context for your filter, so the answer would be you can't get the QTD as data already has been filter by previous week. But if you didn't add this filter to context, I certainly sure your formula above would not retrieve the desired result.
Thank you for your reply!
Please find above sample workbook with data.
- First tab includes as amount and QTD amount but with filter "Previous Week"
therefore QTD data here is incorrect. How can I exclude filter to calculate QTD and Amount in one sheet and
- Another tab with QTD data that is correct (for checking)
Could you have a look?
Thank you so much! It works!)