How to put count and sum both in one report

keval3
Tera Contributor

Hi Team,

 

I have created one report with type 

Multidimensional reports in witch I want both Aggregation Sum and count. can someone tell me how to do it?

Thanks & Regards

KP

11 REPLIES 11

keval3
Tera Contributor

Hi @AndersBGS ,

 

I am using type as 

Multidimensional report so this thing is possible over there?

Regards

KP

Hi @keval3 ,

 

What do you refer to when writing "multidimensional report"? This is not a report type available in ServiceNow.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

keval3
Tera Contributor

@AndersBGS ,

 

Sorry it is multi level pivot table.

 

Hi @keval3 ,

 

No, based on the report type then it's not a possibility. Here you can only add drilldown - not additional datasets:

AndersBGS_0-1709642345751.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @keval3 ,

 

This I don't get "Multidimensional report" - Can you please explain what you refer to. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/