Question about Choosing Filter in Excel Pivot Table

Help StudioX
, ,
1

I’ve searched plenty of posts in UiPath Forum but quite not able to find the answer I want yet.

May anyone help on below:
Is it possible to use StudioX (better no VBA involved) to select a item under pivot table top filter.

  • For example, I wish to select 2020-11-14 in cell B5, how can I do so?
    (I’ve tried use the “write cell” function, but seems the date format are not able to be matached)

Thanks a lot!

RPA Question
RPA Question914×170 23 KB

2

@vincentkin912 - If that cell value (B5) falls with in your source Range, then you can point out that value by Showing the plus and Indicate in excel.

I have tried to add Filter to my existing Workflow and it worked.

image

image

Output:

image

3

Thank you for replying but what if I would like to proceed next step:

Only filter out specific category, for example “Warehouse Project”, in D column of your photo attached.
(Currently your default filter option in D column is “(All)” )

Thanks a lot

4

@vincentkin912 - Here you go…I found the work out…

  1. Use Appllication → Click (“All” text on the report Filter) → Type into Search (your value) Use Enter at the end…

image
image485×752 42.1 KB

Output: Look at the report filter has the value instead of All…
image

Please mark this as Solution, if its solves your query.

1 Like
'Filter' in Pivot table in StudioX
5

@vincentkin912 - I have improvised the above solution (Above one has the hardcoded value)…

This time i used the read cell activity to read that cell and stored that value(As Project Value) for later use. Later, used this value to type into the Search…that’s it…work beautifully…

image
image381×686 23.7 KB

1 Like
6

Oh Thanks, I kept using “Excel” but nearly forget about this simplest way “Application” to do so.

2 Likes
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.