How to sort the column in pivot table

Help StudioX
,
1

Hello, I’m new to UiPath, I’m practising “create pivot table”, and wondering if I can sort the “value” column as we usually do in Excel. I tried “sort range” several times, but failed. not sure whether “sort range” is the correct way to do the simply sorting for pivot table.

1 Like
2

As there is no official activity, You can use VBA code for sorting pivot table.

1 Like
3

Hey @CHEN_YIJIAN

Could you please show the screenshot and highlight on what you are trying to sort here ?

Thanks
#nK

4

Hi

Welcome to uipath forum

I think there is no direct activity to sort pivot table in excel in studioX

You can try with vb script here with invoke code activity

This example sorts the Company field in descending order, based on the sum of sales.

ActiveSheet.PivotTables(1).PivotField("Company") _ 
 .AutoSort xlDescending, "Sum of Sales"

Cheers @CHEN_YIJIAN

5

image
image1920×1035 99.8 KB

screenshot post. hope it explains well. thanks.

1 Like
6

thanks for your reply, may I know how to use “invoke code activity”?

1 Like
7

Hey @CHEN_YIJIAN

This should help - Sort Table

If that’s not let us know, what’s the challenge/issue you are facing.

Thanks
#nK

8

thanks for your feedback, example in this link can not be opened, coz I’m StudioX user not Studio user. Also according to other people’s advice under this question, I would resort to VBA to see if it works.

1 Like
9

Hey @CHEN_YIJIAN

It is Sort Range in StudioX.

Have you tried that and any issue ?

Thanks
#nK

10

Hi

Check this doc for an example on how to to use invoke code activity

Cheers @CHEN_YIJIAN

11

thanks for reply. it seems no such activity in StudioX.

1 Like
12

image
Main.xlsx (6.9 KB)
attached the main.xlsx for reference.

13

Fine

Go to activity panel and right click that filter symbol

Enable SHOW DEVELOPER and then try searching for that activity

Cheers @CHEN_YIJIAN

1 Like
14

@CHEN_YIJIAN Can you share the sample excel file with PIVOT table that you created

15

@CHEN_YIJIAN You can read the PIVOT table to a data table from where you can sort using Sort data table activity (Ascending or Descending)

Please find the attached sample workflow based on Ascending sorting

Example.zip (25.5 KB)

1 Like
16

after enabled “Show Developer”, it has only “Invoke Method” rather than “Invoke Code”, FYI.

17

thanks for this new thought. unfortunately the attachement can’t be opened due to the incompatibility…anyway i will try to figure it out by using this method. thank you!

image
image860×249 11.9 KB

18

I tried to switch to Studio, but failed. export log attached, could you pls help verify whether the pkgs are available? thanks.
output.txt (3.2 KB)

image
image1401×489 48.5 KB

19

@CHEN_YIJIAN Can you please go to your package manager and check the latest version of excel, system and UIautomation activities. So that I can degrade the packages to that version and can send you updated code

20

@CHEN_YIJIAN Try with the attached one

Example.zip (51.2 KB)