How to bring Category & Subcategory in the report while pulling from Incident Table

shaik_irfan · ‎11-01-2018

AbdulAzeez · ‎11-01-2018

Since Category & Subcategory is not extended from TASK table this is wont be visible on the columns, however in the columns if you extend the Parent field and search for category [incident], subcategory[incident] if you add to the columns then it will be available..

Once you extend the parent filed search for subcategory as shown below:

View solution in original post

Afifa1 · ‎11-01-2018

Hi Irfan,

You can use group by category

and add subcategory in additional group by in your report.

regards,

Afifa

shaik_irfan · ‎11-01-2018

I need this in Columns can you please help me with screenshot >

Afifa1 · ‎11-01-2018

Hi ,

PFA doc for the same.I have attached screenshot.

Mark helpful if that is correct.

Regards,
Afifa

shaik_irfan · ‎11-01-2018

Thank you for the reply but as said earlier mine is TASK table since i am combining multiple tables