Pivot Table - unchecked 'Show Zero Values' - first row deleted as well
I think I found a bug in the pivot table.
I am showing some information with country rows and month columns. The countries are dual type to show them in a certain order.
With 'Show Zero Values' checked in Data Handling it shows all countries, but there are zero values for the countries in the top:
If i now uncheck this option it gets rid of all the countries without information, but also cuts of 'DE' which does not have a zero value: