Hi all,
I'm trying to create the following logic for column '?' based on the header column:
context
header: the original column I want to rank against
temp: a constant 1 for the row number logic
row number: a row number ordered by temp ascending (recommended on the forum)
header identifier: a conditional column using 'CASE WHEN [columnA] = 'Market' THEN 'START' END'
Currently trying a rank & window using rank-ordered by the 'row number' and partitioned by the header identifier but at the point of 'START' it removes that row, the row count skips and the rank & window output works as a row number.
All support appreciated