Pivot Table

Shpilmaa
Tera Contributor

Hi Guys,

 

i made a pivot table,

 

Shpilmaa_0-1705321945356.png

 

and i want to filter where is number 1 ( i dont want to see rows where is no 1)

is it possible?

 

 

 

3 REPLIES 3

Maik Skoddow
Tera Patron
Tera Patron

Hi @Shpilmaa 

this is not possible in ServiceNow. What you want is like a second round of filtering that means on the results. But ServiceNow can only print the results.

So if you want to filter in a second round you have to export the data to Excel to perform the operations there.

Maik

Maybe i can filter here? to remove every group that contains 1

Shpilmaa_0-1705337625951.png

 

Hi @Shpilmaa 

I already answered your question to the best of my knowledge and experience. Nothing to add from my side.

Maik