I have a pivot table with expandable columns and rows and the table is using a calculation that is resulting in percentage. The issue is that when nothing is expanded, the table shows 100% everywhere (which is correct behavior considering that nothing is expanded). I found the option to expand all but it doesn't work for me, as I would prefer if not all are expanded.
My question here is - is there a way to expand only the rows to the left, so that the pivot table is not summing up to 100%.
.png "Former Employee"){kind=icon}
