https://www.servicenow.com/community/community-central-forum/creating-report-as-per-the-desired-outcome/m-p/2901582#M18 <P>Hi everyone,<BR />I had a specific case related problem.</P><P>&nbsp;</P><P>As you can see in the attached picture, I have created a report to show the no. of tickets related to my team. It's a team of 5 people. After I applied all the filters in report to get thew data I want, I need to plot a similar chart where I need team members names in columns &amp; their assigned tickets in rows as per the priority &amp; state.<BR /><BR />But the problem I'm facing is some of the tickets are opened by me teammates that are assigned to themselves, some are opened by them that are unassigned &amp; some are opened by others assigned to my teammates. This is creating multiple columns &amp; sub columns in the table.<BR /><BR />What I need in table is 5 columns of all team mates names showing all the tickets that are related to them (i.e. opened by &amp; assigned to) in order of severity &amp; state and not see any other names in the table.</P><P>&nbsp;</P><P>Can anyone please suggest me appropriate fields &amp; steps to use in table column filter to achieve the result ?</P><P>&nbsp;</P><P>Hope someone can help with this.</P> Thu, 18 Apr 2024 06:23:39 GMT jarahi9409 2024-04-18T06:23:39Z https://www.servicenow.com/community/community-central-forum/creating-report-as-per-the-desired-outcome/m-p/2901582#M18 <P>Hi everyone,<BR />I had a specific case related problem.</P><P>&nbsp;</P><P>As you can see in the attached picture, I have created a report to show the no. of tickets related to my team. It's a team of 5 people. After I applied all the filters in report to get thew data I want, I need to plot a similar chart where I need team members names in columns &amp; their assigned tickets in rows as per the priority &amp; state.<BR /><BR />But the problem I'm facing is some of the tickets are opened by me teammates that are assigned to themselves, some are opened by them that are unassigned &amp; some are opened by others assigned to my teammates. This is creating multiple columns &amp; sub columns in the table.<BR /><BR />What I need in table is 5 columns of all team mates names showing all the tickets that are related to them (i.e. opened by &amp; assigned to) in order of severity &amp; state and not see any other names in the table.</P><P>&nbsp;</P><P>Can anyone please suggest me appropriate fields &amp; steps to use in table column filter to achieve the result ?</P><P>&nbsp;</P><P>Hope someone can help with this.</P> Thu, 18 Apr 2024 06:23:39 GMT https://www.servicenow.com/community/community-central-forum/creating-report-as-per-the-desired-outcome/m-p/2901582#M18 jarahi9409 2024-04-18T06:23:39Z