Hi,
I would like to show the folliwing in a piovt table
2020 Nov / Dec
2021 Jan / Feb
so using filter ;I have tried using advanced filter also but not sure about how, but my main is the pivot, I have attached the above and a pivot with![]()
FILTER(F4:G51, (( F4:F51 >=I10)*(F4:F51 <J10)) +((F4:F51 >I11)*(F4:F51 <J11)) )
a date hierarchy showing the dates required but it is also show all the other months I don't want to see, help?
Richard
Bookmarks