Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a question regarding the pivot table.
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%.
Thanks in advance!
Best Regards,
Shelly
Hello @ShellyG ,
Partial expansion is not something you can do today, but it could be a feature request on our Qlik Ideas forum.