Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Answered my own question!
If(Above(TOTAL Partcode)=Partcode,Null(), <Formula for Column Measure>)
Answered my own question!
If(Above(TOTAL Partcode)=Partcode,Null(), <Formula for Column Measure>)