Is there any way that I can create a pivot table which only shows the previous 4 weeks data dynamically.

I can create a dates filter for this month or last month etc, but if I want to create the last 4 weeks I need to create an extra column in the data. If I do this, it shows the blanks in the pivot & If I exclude the blanks will this no longer be dynamic will it?




I would add in a helper column in the underlying data, using something like the if function. The if function should update automatically and you'll just need to refresh the pivot table.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.