By standard, repeated values in pivot table are only shown once. I made an example sheet to illustrate:This becomes a problem for people who use filters over pivot tables:Notice how Donald's sales to customer #001 disappeared?I think this could be solved by filling the blank cells with repeated values. Is it possible to do it on Google Sheets?
How to show instead of hide repeated values in pivot table?
google spreadsheets