topic Fixed rows in Pivot Table when filter the Dimension in App Development https://community.qlik.com/t5/App-Development/Fixed-rows-in-Pivot-Table-when-filter-the-Dimension/m-p/1776987#M60257 <P>Hi There,</P><P>I meet a problem when filter the dimension that field is same in the pivot table,and this dimension can't be fixed,thank you.</P><P>This my measure :&nbsp;Sum({&lt;MeasureType={"LC-RMB"},Market={'$(vMarketOfValue)'},Company,CompanyShownName,YearMonth={"&gt;=$(vSelectedCYStartM)&lt;=$(vSelectedCYCM)"}&gt;}Measure)/1000000/$(vMoneyConv)&nbsp;</P> Mon, 25 Jan 2021 01:57:27 GMT AndersLiu 2021-01-25T01:57:27Z Fixed rows in Pivot Table when filter the Dimension https://community.qlik.com/t5/App-Development/Fixed-rows-in-Pivot-Table-when-filter-the-Dimension/m-p/1776987#M60257 <P>Hi There,</P><P>I meet a problem when filter the dimension that field is same in the pivot table,and this dimension can't be fixed,thank you.</P><P>This my measure :&nbsp;Sum({&lt;MeasureType={"LC-RMB"},Market={'$(vMarketOfValue)'},Company,CompanyShownName,YearMonth={"&gt;=$(vSelectedCYStartM)&lt;=$(vSelectedCYCM)"}&gt;}Measure)/1000000/$(vMoneyConv)&nbsp;</P> Mon, 25 Jan 2021 01:57:27 GMT https://community.qlik.com/t5/App-Development/Fixed-rows-in-Pivot-Table-when-filter-the-Dimension/m-p/1776987#M60257 AndersLiu 2021-01-25T01:57:27Z