Hi all,
I've got a workbook that gets updated every year (for the past 4 years). It's clients send back their returns for how many items they have.
This year about half the clients never returned anything.
The data tab has the columns "Year", "Client name", "product", "Amount" and a new column I've added called "Returned 2020" & put Yes or No in each row (depending if they did or didn't return.
There's 3 products, so each client gets 3 rows per year. There's a pivot linked to the data that has "Year" in Columns, "Product"in Rows, and "Sum of amount" in Values.
When I create a slicer to select Yes/No for 2020 client returns, it doesn't show the previous years' unless I also select blanks. Is there a way I can have it so that blanks are always selected (I could replace blanks with text or numbers if that would help)?
I've got a workbook that gets updated every year (for the past 4 years). It's clients send back their returns for how many items they have.
This year about half the clients never returned anything.
The data tab has the columns "Year", "Client name", "product", "Amount" and a new column I've added called "Returned 2020" & put Yes or No in each row (depending if they did or didn't return.
There's 3 products, so each client gets 3 rows per year. There's a pivot linked to the data that has "Year" in Columns, "Product"in Rows, and "Sum of amount" in Values.
When I create a slicer to select Yes/No for 2020 client returns, it doesn't show the previous years' unless I also select blanks. Is there a way I can have it so that blanks are always selected (I could replace blanks with text or numbers if that would help)?