However what I am trying to achieve is to have the builder names within a given date (in this case, period) and show the moving average of 4 Weeks. However I am not doing so. the last column is wrong and in your's, it's right. My goal is to capture what you did but in this condensed form. What calculated formula did you use in your example in the last column? Thanks Again!
For table calculations to work, we need multiple periods (4) of data in our current scenario.So, it's better that you work with parameters here instead of filters. If you are still bent on working with filters, then you need to ensure that you have a minimum of 4 periods available in the data for the moving calculation to work.
Here is how I would proceed with a period parameter:
1. Create a period parameter and select a period value.
2. Create a calculated field to show/hide the period based on the parameter value selection.
3. Add the above calculated field to the rows, hide the "Hide" values by right-clicking on it and then suppress the header for this field.
4. You should now have the data for the selected period only.
Hope this helps. Updated workbook is attached for reference.