Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

need help in creating tabular format report

anuradha_balam
Tera Contributor

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. 

 HRR&DSalesMarketing IT
Jan01210
Feb00200
Mar     
Apr     
May     
Jun     
Jul     
2 REPLIES 2

Dr Atul G- LNG
Tera Patron

Hi @anuradha_balam 

 

You can get this; use pivot type in report

AGLearnNGrow_0-1741331135803.png

 

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Dr Atul G- LNG
Tera Patron

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

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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