need help in creating tabular format report

anuradha_balam · ‎03-06-2025

Hello All,

Can someone help me in creating a report in tabular format which looks like below table. I tried with Pivot table but it is taking creation date and not the month. Suggestions would be appreciated.

Requirement: Monthwise major incident count for different streams.

	HR	R&D	Sales	Marketing	IT
Jan	0	1	2	1	0
Feb	0	0	2	0	0
Mar
Apr
May
Jun
Jul

Dr Atul G- LNG · ‎03-06-2025

Hi @anuradha_balam

You can get this; use pivot type in report

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Dr Atul G- LNG · ‎03-06-2025

Then you need to use PA only, in standard reporting it is not possible or convert this report in trend type.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************