Hi all,
I am creating a template for a report to make it very simple for the user to add some raw data and produce a pivot table at the click of a button to summarise the data.
It is all working as expected, except for that one column in the table (which is a SUM value for the revenue) disappears whenever there is no data.
The table is below with the sum column on the right. When I remove the data as the template needs to have no data included then this column disappears. When additional data is added and the table refreshed again then it doesnt come back!
I feel like I must be missing something obvious, but I would like the column to stay and just show no data!
Any help?
I am creating a template for a report to make it very simple for the user to add some raw data and produce a pivot table at the click of a button to summarise the data.
It is all working as expected, except for that one column in the table (which is a SUM value for the revenue) disappears whenever there is no data.
The table is below with the sum column on the right. When I remove the data as the template needs to have no data included then this column disappears. When additional data is added and the table refreshed again then it doesnt come back!
I feel like I must be missing something obvious, but I would like the column to stay and just show no data!
Any help?