Hey, so need help with pivot tables. I want to restrict one of my pivot tables to only show data from a certain date, so I have a column that has dates (so the month and year) and I want to use the show column if to filter out dates.
I've tried using the IF statement, entering the value that I want to show so i want all dates corresponding to January'21 to show up in the table only but can't get this to work. Any suggestions?