How can I change the label of the total fields in a pivot table?

G

Guest

When making a pivot table, there are total and grand total fields. I would
like to change the label of these fields, so that I can write them in French
or Italian, for example.
 
B

Bill Ridgeway

There are two ways-

Change the name of the field (column) names

Have a separate table (either in the same or different worksheet) with
formula taking data from the original. For the 'translation' I would
suggest that the formula should be a IF(English), (French). This should
save any embarrassment if the order is changed).

Regards.

Bill Ridgeway
Computer Solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table grand total location 1
Grand Totals for Pivot Tables 4
Referencing a pivot tables Grand Totals Column 1
Pivot Table Column Totals - XL2003 5
pivot table excel 2
Count of Non-Zero pivot table entries 1
Pivot Table - 3
How do I perform extended calculations in a Pivot Table in Excel 2 4

Top