I am using the following code to filter my pivot table. It hides any data where the date is less than or greater than the specified dates.
I also need to filter by my Account and Team fields. My attempt was to have three seperate blocks of the above code for the filtering criteria however when it gets to filtering the account it shows items outside of the date range.
Is there anyway I can nest the above code so that it checks for the date, account and team all at once and then hide it if it doesn't match the criteria?