Excel Pivoting

Help Studio
, ,
1

I have an excel in this format

image
image372×742 33.7 KB

I have used excel pivoting activity in UiPath for filter this column like below

image
image385×716 30.6 KB

My final Pivoted Data is Coming with date format but not with month format (Filter option)

Final Sheet

image

So what should i do to get the month format instead of date format using “Create pivot activitity”

Forum Engagement Daily Reports
2

Try,

The image shows a configuration screen for creating a pivot table in Excel, with fields for source, destination, and pivot fields specified for rows, values, and columns. (Captioned by AI)
The image shows a configuration screen for creating a pivot table in Excel, with fields for source, destination, and pivot fields specified for rows, values, and columns. (Captioned by AI)661×766 22.3 KB

3

@Kismet_Tosun

What is assed in that field column, Can you mention

4

your assed, APPROVAL DATE,

Just try with column. What will happen

5

@Kismet_Tosun

It is coming like this

image
image1628×322 30.1 KB

until below (CCG column)

image
image1632×296 25.2 KB

6

Firstly remove the filter. Try later,I don’t have any idea

image

7

@Kismet_Tosun

I removed the filter and added the filter option in the pivot table activity

image

But still it is coming as the same

image

8

Try the change format

The image shows a process of formatting cells in an Excel sheet using automation, specifically setting the data type of a specific range to "Text." (Captioned by AI)
The image shows a process of formatting cells in an Excel sheet using automation, specifically setting the data type of a specific range to "Text." (Captioned by AI)769×538 20.8 KB

9

@Kismet_Tosun

The source you mentioned is like main sheet or pivoted sheet

10

@Yoichi

Can you help me out on this