We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

How to have columns repeating instead of nested but in pivot views?

Answered
Jason asked on March 28, 2023

How to have columns repeating and instead of nested, when in a pivoted view. Currently in our system, we need to change the view to a flat view but cannot apply any pivot changes in this view. Instead we want to be able to continue using a pivot view but have the rows repeating when in the hierarchy
 

4 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 29, 2023

Hi Jason,

Thank you for reaching out to us.

We recommend using the classic view and repeat labels with the customizeCell API call. You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/m8op5tk7/ 

Please let us know if it works for you. Looking forward to your response. 

Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster April 10, 2023

Hello Jason,

Hope you are doing well.

We were wondering if you had a chance to test the suggested approach. Could you please confirm if it works well for you?

Looking forward to hearing from you.

Kind regards,
Nadia

Public
Jason April 13, 2023

Thank you! One follow up we had is that we know that after many columns the view would switch to compact view. Would we be able to maintain this suggested approach in that case as well? or would that switch to compact view and thus affect this solution?

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster April 14, 2023

Hello,

Thank you for the response.

An automatic switch to compact would not affect the described approach. It means the labels will still be repeated when you switch back to classic. 

Please let us know if this works for you. Looking forward to hearing from you.

Kind regards,
Nadia

Please login or Register to Submit Answer