https://community.qlik.com/t5/Reporting-Service-Alerting/Tabular-reporting-How-to-achieve-minimized-subdimension-in-excel/m-p/2537915#M2654 <P>Hi Everyone!<BR /><BR />I've just gotten started with Tabular reporting so my experience is somewhat limited.<BR /><BR />Lets say I want to produce a table with two dimensions, brand &amp; product and some measures.<BR />I want the layout/functionality to be close to a pivot table, meaning that I can expand/minimize the products for each brand. Another important aspect in this task, is that the <STRONG>products should be minimized when the file is generated/open.</STRONG><BR /><BR /><BR />When trying the native excel pivot table approach, the report always gets generated as expanded?<BR />Additionally, I've explored grouping on a straight table. However, my approach does not generate a group for every brand but there is a high possibility that I&nbsp;might be missing something in my approaches?<BR />Any ideas how to achieve this functionality?<BR /><BR />Additionally, to my understanding it is not possible to use VBA as reporting only supports xlsx files?<BR /><BR /><BR /><BR /></P> Wed, 03 Dec 2025 08:17:11 GMT Müller 2025-12-03T08:17:11Z https://community.qlik.com/t5/Reporting-Service-Alerting/Tabular-reporting-How-to-achieve-minimized-subdimension-in-excel/m-p/2537915#M2654 <P>Hi Everyone!<BR /><BR />I've just gotten started with Tabular reporting so my experience is somewhat limited.<BR /><BR />Lets say I want to produce a table with two dimensions, brand &amp; product and some measures.<BR />I want the layout/functionality to be close to a pivot table, meaning that I can expand/minimize the products for each brand. Another important aspect in this task, is that the <STRONG>products should be minimized when the file is generated/open.</STRONG><BR /><BR /><BR />When trying the native excel pivot table approach, the report always gets generated as expanded?<BR />Additionally, I've explored grouping on a straight table. However, my approach does not generate a group for every brand but there is a high possibility that I&nbsp;might be missing something in my approaches?<BR />Any ideas how to achieve this functionality?<BR /><BR />Additionally, to my understanding it is not possible to use VBA as reporting only supports xlsx files?<BR /><BR /><BR /><BR /></P> Wed, 03 Dec 2025 08:17:11 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Tabular-reporting-How-to-achieve-minimized-subdimension-in-excel/m-p/2537915#M2654 Müller 2025-12-03T08:17:11Z