I have a excel pivot table and i need to unselect/uncheck some filters in column, Please suggest how can i unfilter some values in pivot table
Can you give a brief about your query with some sample data
Hello @lrtetala, Thanks for the response,
But i want to unfilter some value from the pivot table.
Your solution will help me to filter the specific values, But I want to unfilter the specific values.
Hello @pravallikapaluri, Thanks for the response,
I have an Excel pivot table,
and I want to unfiter some values like cancel order, chatbot feedback from that column.
Great, Thank you!
I will try it out, and let you people know, Thanks!
1 Like
@manjunath.m1
Try by using copy paste range as values of the pivot table sheet and then use filter activity.
Hope it helps!!
Sorry, I didn’t get it. Could you please explain a bit?
Filter activity is giving errors,
And Filter pivot table activity doesn’t advance filter,
Refer the below image flow.
1.use copy paste range activity.select values in what to copy field, Pass the Same sheet name which contains Pivot.
2.Filter whatever you want using configure filter give Rowlabels columnname in the column name.
3.Again use copy paste range activity.select values in what to copy field
Hope it helps!!
Thank you, I will try and let you know, Thanks!
1 Like
Code
Getting error,
I guess it cant past it back to sheet, Because of the Pivot table,
Please help,
Give the same name in the destination also,Like Excel.Sheet(“Pivotmenus2”)
@manjunath.m1
I think last Copy Paste range is not working. So, Try by filtering the unwanted values and use delete rows activity…
But I want those data in the pivot table format only…
After copy and past the data is changed into normal cell values, But I want them as pivot tables as pre-copy and past activity…