Pivot Table - Hide Column values depending upon previous row dimension value?

[AndyC]

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.

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  and the others are measures.

Is there a way to do this?

[AndyC · Accepted solution]

Answered my own question!

If(Above(TOTAL Partcode)=Partcode,Null(), <Formula for Column Measure>)