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:
I just created a test app. It seems like this is a bug. Unfortunately I can not create a qvf and upload it, but I can supply you with an xlsx to load.
In the Dataeditor load the file like this:
Map: MAPPING LOAD * INLINE [ country, order DE, 0 GB, 1 IT, 2 US, 3 ]; LOAD Dual(Country, ApplyMap('Map', Country)) as Country, Value, "Month" FROM [lib://path/to/file\Test.xlsx] (ooxml, embedded labels, table is Tabelle1);Then create a VizLib Pivot Table with Country as rows and Month as column. For the Value use the following code:
You can observe the same behaviour as in my screenshots.
I just created a test app and it seems like this is a bug. Unfortunately I can not upload a qvf, but I can supply you with the xlsx to load.
In the dataeditor load the file with the following code:
Map: MAPPING LOAD * INLINE [ country, order DE, 0 GB, 1 IT, 2 US, 3 ]; LOAD Dual(Country, ApplyMap('Map', Country)) as Country, Value, "Month" FROM [lib://path/to/file\Test.xlsx] (ooxml, embedded labels, table is Tabelle1);Then create a VizLib Pivot Table with the country as rows and Month as the column. For the calculated value use this code:
You can observe the same behaviour as in my screenshots