Need help in ServiceNow Report

[AnamN]

Hi Team,

I need help with ServiceNow Report.

We have table with column as below fields

State (In Progress/Complete/Cancel) , Number of Incident, Number of Change, Number of problems

and we want to display report like below:

State	Number of Incident	Number of Change	Number of problems
In Progress	3	4	6
Complete	6	6	6
Cancel	1	5	5
Total	10	15	17

[AnamN]

@Ankur Bawiskar @Maik Skoddow  Can you please help here ..Thanks

[Dr Atul G- LNG]

Hi @AnamN 

Report Type = Multi Pivot

[Dr Atul G- LNG]

You can modify the condition as per requirement

[AnamN]

Yes I have tried that option , but unfortunately there is a limitation of rows and columns in Multipivot report type. I think only 5 rows and columns can be selected. there are around 150 fields (columns) for which we need this report.