Comparing two different rows in reportnet report

[smtest]

hi all,
i have a data that looks like this:

column1  column2    column3    Revenue  Billing
1234        2222                            800
1234                            2222                     1000

Expected resultset
when column2 = column3

column1  column2    column3    Revenue  Billing

1234         2222           2222         800      1000

Please advice how i can do this using reportstudio or even sql

thanks