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.
I understand the second picture is the query/source data.
Then you must change your query. It produces a crosstabular format which is not suitable for a pivot table. You need a record list.
To get a record list you have to unpivot the crosstabular format. This is provided by Power Query.
Detlef_Lewin I don't know the process you are talking about. I'm sending my Excel spreadsheet. Can you implement the solution?
In your case you just have to delete the last query step "Pivoted Column".
And then recreate the pivot table.