Pivot Table | Expand rows

[oleksii_pohibsa]

Hello! I have a pivot table with some categories-groups-subgroups...

Some of groups and subgroups contain Null values (I need this data to be shown in the table).

But my problem is expanded rows at the beginning in all groups, subgroups with Null values. I need expanded only by click

[pensa-qlik]

Hello,

Have you tried checking the setting 'Fully Expanded' in the Pivot table settings?

Click the pivot table>appearance>un-check the fully expanded field.

Also, under the data tab, under categories, groups and subgroups, you can check 'Include Null Values' to ensure they are included. 

Hope this helps!