Forum Discussion
Solved
Added Total to header in pivot table
Hello, the titles that normally appear as short dates are preceded by the word "Total" in the pivottable. I have "Don't show subtotals" and "Grand totals off" in the design section. I looked at the ...
In your case you just have to delete the last query step "Pivoted Column".
And then recreate the pivot table.
It's the total for each of your fields.
You can change/overwrite the text in the headings.
@DetlefLewin
this header field specifies the date.
so it doesn't make sense to write the total in front of it.
It doesn't make sense to delete and replace. My query is constantly being renewed.
this header field specifies the date.
so it doesn't make sense to write the total in front of it.
It doesn't make sense to delete and replace. My query is constantly being renewed.