https://community.qlik.com/t5/QlikView/Is-it-possible-to-do-a-Pivot-table-with-dynamic-dimension/m-p/1708975#M1314034 <P>I am exploring whether Qlikview can do a pivot table manually.</P><P>Defined two table, one is to replace Pivot Row (ReportMonth), the other to replace Pivot Columns (ForecastMonth). And use expression to calculated pivot table.</P><P>I tried few expression, the first one give me sum all of forecast month.</P><P>=SUM({&lt;[Forecast Report]=P(ReportMonth)&gt;}[Forecast Qty])</P><P>How to separate it by Forecast Month?</P><P>I tried below one, not working</P><P>=Aggr(SUM({&lt;[Forecast Report]=P(ReportMonth),[Forecast Month]=P(ForecastMth)&gt;}[Forecast Qty],ForecastMth))</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 26 Jan 2026 18:19:17 GMT YJ_SG 2026-01-26T18:19:17Z https://community.qlik.com/t5/QlikView/Is-it-possible-to-do-a-Pivot-table-with-dynamic-dimension/m-p/1708975#M1314034 <P>I am exploring whether Qlikview can do a pivot table manually.</P><P>Defined two table, one is to replace Pivot Row (ReportMonth), the other to replace Pivot Columns (ForecastMonth). And use expression to calculated pivot table.</P><P>I tried few expression, the first one give me sum all of forecast month.</P><P>=SUM({&lt;[Forecast Report]=P(ReportMonth)&gt;}[Forecast Qty])</P><P>How to separate it by Forecast Month?</P><P>I tried below one, not working</P><P>=Aggr(SUM({&lt;[Forecast Report]=P(ReportMonth),[Forecast Month]=P(ForecastMth)&gt;}[Forecast Qty],ForecastMth))</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-do-a-Pivot-table-with-dynamic-dimension/m-p/1708975#M1314034 YJ_SG 2026-01-26T18:19:17Z