I'm trying to do multiple label filters in a pivot table for WEEKNUMBER, which is a column field. I need to exclude (BLANK) and actual blanks. I know how to apply one but not two. I can't do a manual filter for both because I need new week number values to be included every time I refresh data. Is there a way to exclude actual blanks in the source data?
Bookmarks