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

posted on October 1st, 2019

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

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

3 answers

Please login or Register to Submit Answer