Added Total to header in pivot table

[deniztopcu]

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 pivot table options and field options but I couldn't find the Solution.
Is there a solution to make the word total not precede the short date.

https://r.resimlink.com/tkZVY8EHv.jpg

https://r.resimlink.com/ZeVs_Q.jpg

 

[RoryA]

It looks like those are value fields in which case the pivot table will always add a notation for the formula used (In English it prefixes them with 'Sum of'. You cannot stop it from doing that with a normal pivot table, but you can alter the captions - as long as they do not match the name of a field in the data source. So, for example, you could add a space at the end of the name so that they look the same but are actually different.

 

[deniztopcu]

It looks like those are value fields in which case the pivot table will always add a notation for the formula used (In English it prefixes them with 'Sum of'. You cannot stop it from doing that with a normal pivot table, but you can alter the captions - as long as they do not match the name of a field in the data source. So, for example, you could add a space at the end of the name so that they look the same but are actually different.

Thank you for your answer, but my Source table changes from time to time (10-20 times).
it gives an error when it is like this.

 

[RoryA]

What gives an error?

 

[deniztopcu]

What gives an error?

this is not a system error.
For using the headers in my calculations
it gives error about my calculations.

 

[RoryA]

So, what calculations and what error?

 

[deniztopcu]

If value field names don't change in pivot tables, doing this manually won't solve the problem for me, adding more unwanted workload.


I have this code. but there are some functions that only work with office365.
I will continue like this until these features come to normal versions.

=LET(
howManyYears, 5,
symbols, UNIQUE(Combined_tIFinancials[Symbol]),
itemCodes, TRANSPOSE(UNIQUE(Combined_tIFinancials[ItemCode])),
years, TAKE(DROP(Combined_tIFinancials[#Headers],,2),,howManyYears),
itemHeaders, INDEX(itemCodes,,QUOTIENT(SEQUENCE(1,COLUMNS(years)*COLUMNS(itemCodes))-1,howManyYears)+1),
yearHeaders, INDEX(years,,MOD(SEQUENCE(1,COLUMNS(years)*COLUMNS(itemCodes))-1,COLUMNS(years))+1),
totals, SUMIFS(INDIRECT("Combined_tIFinancials[" & yearHeaders & "]"),Combined_tIFinancials[Symbol],symbols,Combined_tIFinancials[ItemCode], itemHeaders),
dataTable, VSTACK(itemHeaders, yearHeaders, totals),
symbolColumn, VSTACK("","",symbols),
result, HSTACK(symbolColumn, dataTable),
result
)


Thanks