can you please attach the last workbook so I can check your solution ?
However it's not what I ment exactly,
in order to create what I was asking I need a way to create a date filter only on one column,
on one colums i will define a filter so that we can select a specific day
on the 2nd column i will need to filter it so it will identify the day of the week selected in the first colums and then calculate and output an Avg. of the same day of the week over the last month/year
For example, i need 1 column which shows the pageviews yesterday on each zone (lets use alpha beta and gama as zones),
2nd column should show an avarege of all wednesdays in the last month (excluding yesterday)
zone monday avg of all mondays ( previous the one selected)
alpha 15462 13456
beta 12345 12453
gama 25646 12346
in theory this should visualise into 2 trend lines, one is the performance of the day selected and the other is the average of all of the same days of the week previous to the one chosen.
Getting hard time to explain myself here :)