I have a problem building a flag in script. I have use previous and get a correct output, expect first row.
Here is my table.and this is for changeflag if(previous(dimension)=dimension ,0,1)
What I want is to get a 1 on the first row With a New Dimension. I think that the first 1 will be there because previous find null and compare it With the first row.
Any trix to avoid this scenario?