When a Pivot transformation is used to create an aggregated column (e.g., Sum), the column disappears when the input data has no rows.
For example:
A Pivot transformation creates a Sum column.
A Table visualization uses the Pivot-generated column.
The query is changed so that it returns 0 rows.
The Pivot-generated aggregated column is no longer available, and therefore disappears from the Table visualization.
We would like to have an option to preserve the Pivot-generated column in the data table and Table visualization even when the input data has 0 rows.
This would allow the Table visualization structure to remain unchanged when the query temporarily returns no data.