I just started to learn RPA, i already create system for save attachment excel from outlook, then i create the pivot table. But Now, i confused because i have to sort one of the columns.
Did you have any idea of next step i have to do after create the pivot table to sort one of the colum? Am i have to copy the pivot table as data table in new sheet? or i just have to use invoke code after create the pivot ?
Thankyou
Welcome to @UiPath_Community
I would suggest while you are creating the pivot table and giving the input source, just sort the source range/table before creating the pivot table, using the Sort Range Activity.
Thankyou Mr.Ajay, but actually the target column that i need to sort is column in formatted previous day, which means it will update everyday. like in this attachment
this is the process i need
first, i have to create privot table. Then after that (Shown in pict1), the table value is unsorted. I want to Sort column Day-1/previous day/in cell contain number “24” using Descending method.
actually i still have another expectation step to capture just Top 10 value
from Day-1 and Day-2. But for now, i am focusing on sorting that column.