Can we define custom report view in custom report

Dear ,

We have one custom report (SQL query), now our requirement we have to show data as per user login

For example if User ABC login report shows only custom Data which we define For ABC (IT Data) and when User XYZ login it shows only that which we define for XYZ (Finance Data) or if any other user login reports shows all data

How can we do it data model sql query

and also where we can define custom data for User ABC (IT Data) or XYZ (Finance Data)