Get Free Trial

Can I change the description of the subtotal label?

Answered
Mauel Santizo asked on November 20, 2020

The problem i have is that when the pivot sheet has more than 2 columns, the subtotal label get too large. For example “Level1 tag – Level2 tag – level 3 tag total”. There is attached a real example of our pivot table issue. 
There is a way to fix o customize the description of the total tags? 
 
Kinds regards, 
Manuel.

3 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster November 24, 2020

Hi Manuel,
 
Thank you for posting your question.
 
In similar situations, we often suggest using the pivot table localization for modifying the totals labels in your grid. You might also consider the customizeCell() API call, which gives you many more customization possibilities.
 
In case this doesn’t help, it would be great if you could send us a sample where the mentioned behavior is reproducible, allowing us to take a closer look and help you find the most suitable solution.
 
Looking forward to your response.
 
Best regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster December 1, 2020

Hi Manuel,
 
Hope you’re doing well.
 
Just checking in to ask if you’ve had a chance to look through our previous response. Have you found it helpful, or is there still anything we could help you with?
 
We would be happy to hear your feedback.
 
Regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster December 9, 2020

Hi Manuel,
 
How are you?
 
We were wondering if you’ve received our response. Is your initial question still relevant?
 
Please let us know your thoughts.
 
Kind regards,
Mykhailo

Please login or Register to Submit Answer