asked on March 29, 2022
A pivot table is setup with report filters, rows , columns and values selected.
There are an unexpected behavior when:
When user chooses "Expand All" on the row header, the "XF" column will disappear.
The total count of Cntr ID is 22, while there should be only 12 OF containers at the selected block.
There are 10 more "XF" containers that should show up in an XF column.
So, when rows values are empty, expandall does not show them?
⋅ March 29, 2022
Hi, Henry!
Thank you for reaching out to us.
As you correctly mentioned, the members will not be shown if they are containing empty values. Still, you can change the default behavior using the showEmptyValues : true inside the options object.
You are welcome to check this example, where empty values are shown on grid: https://jsfiddle.net/flexmonster/g62n7hbk/.
Please contact us if more questions arise.
Best Regards,
Maksym
