asked on April 4, 2024
We want to represent Unbalanced hierarchy in Flexmonster pivot table. We pivoted the hierarchy into L1, L2, L3, L4 fields but we have problem that balk values are shown where there is no data on L4 or L3.
Do you have any idea how to represent this? For example, disabling drill-down where next level have blank value?
See atached example.
⋅ April 4, 2024
Hello, Janez!
Thank you for reaching out to us.
We kindly recommend creating a multilevel hierarchy from your fields. This way, only existing members would be shown when drilling down to the lower levels. You can configure a multilevel hierarchy using mapping:
report: {
dataSource: {
//other data source properties
mapping: {
"L1": {
hierarchy: "Hierarchy"
},
"L2": {
hierarchy: "Hierarchy",
parent: "L1"
},
"L3": {
hierarchy: "Hierarchy",
parent: "L2"
},
"L4": {
hierarchy: "Hierarchy",
parent: "L3"
}
}
},
//other report properties
}
We have prepared a JSFiddle to illustrate the idea: https://jsfiddle.net/flexmonster/bpfkag8s/.
Please look through our docs for more details about multilevel hierarchies and other mapping properties: https://www.flexmonster.com/doc/mapping/#multilevel-hierarchies.
Hope you will find our answer helpful.
Please let us know if the suggested approach works well for your case.
Kind regards,
Solomiia
⋅ April 16, 2024
Hello, Janez!
Hope you are having a great week.
Our team is wondering if you had some time to try configuring multilevel hierarchies using mapping. Could you please let us know if the suggested approach works well for you?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ April 17, 2024
Hello,
Yes I tried your suggested apporach and it worsk for us perfect.
Thnak you
Janez
⋅ April 17, 2024
Hello, Janez!
Thank you for your feedback.
We are glad to hear everything works well for you.
Feel free to contact us in case of any other questions.
Kind regards,
Solomiia