Need Logic to display report format

[SGD]

Hi,

I am trying to create one report which displays vehicles which are classified as repeated offender if the same wagon registers AoA > 30 mRad on 2 or more consecutive passes over last 6 months duration.

Please refer attached the screenshot of the same.

Please anyone can suggest logic to impement it and how to display data in shown format?

Your help is highly appreciated. Thanks in advance.