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

[Ankur Bawiskar]

@AnamN 

Atul has shown the approach. Did you try that?

[AnamN]

Yes I tried but 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.