Hey!
We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

Merge column

Answered

Can we merge the two column into one? Find the attachment

Attachments:
samplepivot.xlsx

3 answers

WebDataRocks Team WebDataRocks June 10, 2020

Hello, Uma,
 
Thank you for your question.
 
We would like to inform you that merging two columns into one is not possible. However, it is possible to override the styles for the wdr-header-c and wdr-empty CSS classes. This will allow hiding the borders so the cells look merged visually.
 
We hope it helps.
 
Kind regards,
WebDataRocks team

Ashlesha July 14, 2020

I have a similar question.
Can you please send a sample if possible for merging these cells using the wdr-header-c and wdr-empty CSS classes. It would be very helpful.
 
Thanks

WebDataRocks Team WebDataRocks July 15, 2020

Hello, Ashlesha,
 
Thank you for writing to us.
 
We have prepared an example that solves your issue. As you can see expanded hierarchy members in columns (for example, Australia) have no borders inside.
You are welcome to use the CSS to customize more and get the desired view of a merged column.
 
We hope it helps.
 
Best regards,
WebDataRocks team

Please login or Register to Submit Answer