https://community.qlik.com/t5/App-Development/Pivot-Table-Hide-Column-values-depending-upon-previous-row/m-p/2505179#M103906 <P>I've got a pivot, with some columns (both dimensions and measures) that are per Partcode, and other that are per line. I want to leave the column blank if it is a repeat of the previous row.</P> <P>E.g. for this part, I want to exclude rows 2-4 for the highlighted values if the partcode is the same as the previous row. Those with the red-ringed columns are dimensions&nbsp; and the others are measures.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AndyC_2-1739191862650.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/177381i8B1B5C837D8BF808/image-size/medium?v=v2&amp;px=400" role="button" title="AndyC_2-1739191862650.png" alt="AndyC_2-1739191862650.png" /></span></P> <P>Is there a way to do this?</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 10 Feb 2025 12:52:27 GMT AndyC 2025-02-10T12:52:27Z https://community.qlik.com/t5/App-Development/Pivot-Table-Hide-Column-values-depending-upon-previous-row/m-p/2505179#M103906 <P>I've got a pivot, with some columns (both dimensions and measures) that are per Partcode, and other that are per line. I want to leave the column blank if it is a repeat of the previous row.</P> <P>E.g. for this part, I want to exclude rows 2-4 for the highlighted values if the partcode is the same as the previous row. Those with the red-ringed columns are dimensions&nbsp; and the others are measures.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AndyC_2-1739191862650.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/177381i8B1B5C837D8BF808/image-size/medium?v=v2&amp;px=400" role="button" title="AndyC_2-1739191862650.png" alt="AndyC_2-1739191862650.png" /></span></P> <P>Is there a way to do this?</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 10 Feb 2025 12:52:27 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-Hide-Column-values-depending-upon-previous-row/m-p/2505179#M103906 AndyC 2025-02-10T12:52:27Z https://community.qlik.com/t5/App-Development/Pivot-Table-Hide-Column-values-depending-upon-previous-row/m-p/2505215#M103923 <P>Answered my own question!</P> <P>&nbsp;</P> <P>If(Above(TOTAL Partcode)=Partcode,Null(), &lt;Formula for Column Measure&gt;)</P> Mon, 10 Feb 2025 15:29:04 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-Hide-Column-values-depending-upon-previous-row/m-p/2505215#M103923 AndyC 2025-02-10T15:29:04Z