How to remove the first line in a pivot table

[sandhyareddy (Kalyani)]

In a pivot table how can we remove the first line in a table

[rohith.prabhu]

Hi @sandhyareddy ,

Can you please explain what is actually needed with a example or screenshot to help you with the exact solution.

Regards,
Rohith

[Gokul001 (Gokul Balaji)]

Hi @sandhyareddy

Can you share the screenshot and explain bit more about your query

Regards
Gokul

[lukas.gamper]

Hello,

you want to remove the data from the pivot itself? Like the headers? please be more specific,
to my knowledge you can´t remove a row from the pivot itself, unless you remove it from the datasource.

Best Regards
Lukas

[sandhyareddy (Kalyani)]

In the attached screenshot i want to remove first row i.e count of environment using uipath

[sandhyareddy (Kalyani)]

In the attached screenshot in the pivot table, i want to remove first row i.e count of environment

[sandhyareddy (Kalyani)]

here i attached screenshot

[lukas.gamper]

Hello,

you could hide it or filter it, if you truly want to remove it, you would have to remove it from the data source (to my knowledge).

Best Regards

[Gokul001 (Gokul Balaji)]

Hi @sandhyareddy

After the Pivot created, We can use Read range activity → Store it as Dt

Use Delete row activity and Delete the first row.

Regards
Gokul

[Gokul001 (Gokul Balaji)]

For Reference @sandhyareddy