Get Free Trial
Get Free Trial

Can we merge the rows values of grouped fields when exported to excel sheet?

Answered
Kranthi asked on October 1, 2019

Hi Team,
 
When I export the grouped pivot data to excel file. Can I have the grouped  data of columns merged, Such that when I have filter on other column I will not miss the grouped column data.
 
Please find the attachment for reference. I am expecting the Canada data cell and the below empty cell to be merged, so that when I apply filter on Total Sum of price with 5166 value, The value Canada wont be missed.
 
Thanks,
Kranthi
 

Attachments:
MergeExcel.PNG

3 answers

Public
Dmytro Zvazhii Flexmonster October 1, 2019

Hello Kranthi,
Thank you for your question.
 
We recommend trying customizeCell approach for your case: https://www.flexmonster.com/api/customizecell/.
Here is the possible example: https://jsfiddle.net/flexmonster/zkm26d6h/.
 
Please let us know if everything works fine for you.
Regards,
Dmytro

Public
Mauel Santizo October 11, 2019

Hello, 
Is there any way to display the rows like this?
Kind regards, 
Manuel

Attachments:
Merge.PNG

Public
Vera Didenko Flexmonster October 17, 2019

Hello, Manuel,
 
Thank you for your question.
 
At the moment merging the cells to achieve the described output is not supported in Flexmonster.
You are welcome to write to us in case of questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer