How to show only attended events in events subpanel

Hi,

I am able to write query as per my wish but the problem is i am unable to hide those rows from sub panel which doesn’t has “Attended” status and it is affecting list view of events module also which i don’t want.

if there is a record in subpanel which don’t have attended status, i don’t want to show that row at all.

Please guide how we can hide rows from subpanel as per query.

Thanks