asked on November 3, 2022
I know it sounds counter intuitive, but our users have a desire to have a large set of columns, and then group those columns by common things. They don't really want to calculate and create pivots so much as creating grouped columnar views. Is that something there is a way to do?
⋅ November 3, 2022
Hello, Nathan!
Thank you for contacting us.
We kindly suggest trying the classic view to achieve the desired grouping behavior.
It needs at least one aggregated measure, but each hierarchy is shown in a separate column, and the members of the next field are grouped by the previous one.
We have prepared a JSFiddle example for visualization: https://jsfiddle.net/flexmonster/1Lje39cb/.
Could you please let us know if the suggested workaround works for your case?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ November 4, 2022
yep, that coupled with a call to expandAll() is what I'm looking for. Thanks!
⋅ November 4, 2022
Hello, Nathan!
Thank you for your swift response.
We are glad to hear that the suggested approach works well for you.
Feel free to contact us if any other questions arise.
Regards,
Solomiia
