When I have a null value in a cell in the classic view and turn on subtotals, the entire row disappears. An example of this can be found here: https://drive.google.com/drive/folders/1feCFH3Xn15cpW_TqGRA_Dslg4ONfofAs.
When I open the pivot in classic and remove subtotals, the "null" customer name causes all the rows to disappear. This is not the behavior I would expect. I'd expect the rows to still exist with a null value in the customer cell. Is there a way to support this behavior?
Thanks,
Brian