Repeat value from previous cell when it is blank per unique account

[karma2046]

When creating a report, I want to have a repeat value from previous cell when it is blank per unique account. I already have a break on the account level but it is still not working. Below is the dummy data.

Account	Current Value	Wanted Value
123	ABC	ABC
123		ABC
456	CDE	CDE
456		CDE
456		CDE
580	FYI	FYI
580		FYI

[Simon_Ye]

try the Windows function LAG Function (Window)

[karma2046]

Hi! Thank you for your response but I am trying to do it on a report level and am current using SAP BusinessObjects BI Platform 4.3. I appreciate your help!