How to put count and sum both in one report

[keval3]

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

[Dr Atul G- LNG]

Hi @keval3 

You cant get both in one report. OOTB it support only one aggregation. 

[keval3]

Hi Atul,

Can we do it with help of 

Configure function field?

Thanks & Regards

KP

[AndersBGS]

Hi @keval3 and @Dr Atul G- LNG ,

@Dr Atul G- LNG , your answer is not correct as you can get both count and sum in one report. 

@keval3 , you need to first create one of the datasets (doesn't matter if it count or sum) and then add a dataset for the opposite - You can read more about adding a dataset here:  https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/t_AddAnAddi...

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

best regards

Anders

[Dr Atul G- LNG]

Thanks @AndersBGS for correcting me. I totally missed out this and i remembered I read about same in one of your other post or in answer.