Compare two rows in straight table

[sunitha_chellaiah]

Hi All,

In the below mentioned table ,I want to compare SQ number row by row. For eg: 

first row of sq number is 19200002 then the first row of above column should show No because sq number doesn't have any previous row.

Second row of above column should show 'Yes' because second row and its previous row of column SQ Number are same.

likewise third row and fourth row should show' Yes'.

Fifth row should show 'NO'.

I have attached the full data table. I have applied above and below function in front end but its not working.

=if(SQ Number =Above(SQ Number),'Yes','No')

SQ Number	Above	OMS Reference	Business Point	Line of Business	LOB
	No
19200002	No	MMR/GR/18/8505	D102T	02	SLD
19200002	No	MMR/GR/18/8505	D102T	02	SLD
19200002	No	MMR/GR/18/8505	D102T	BDP	SLD
19200002	No	MMR/GR/18/8505	D102TC	BDP	SLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD
19200005	No	BGD/DP/18/8455	D002	01	FLD

Thanks in advance

[vijetas42]

try to use Previous().

In new table you can load [SQ Number] and create Previous([SQ Number]) as SQN1 from resident table

and then in straight table add expression as =if([SQ Number]=SQN1,'Yes','No').

[sunny_talwar · Accepted solution]

May be you have multiple dimensions and you need to use TOTAL keyword here?

=If([SQ Number] = Above(TOTAL [SQ Number]), 'Yes', 'No')

[sunitha_chellaiah]

Thank you Sunny!  it's working