How to drag field to area in pivot table

Help Studio
, ,
1

how to drag field to area in pivot table

2

Hey @Lakshya_Garg,

There are some activities in UiPath that you can use to create the pivot table.
image

Or you can use linq to create the pivot, for this you can refer this

Thanks,
Sanjit

3

thanks for reply

but I am using classic activity not modern

4

if this is done by vba then please send me the vba code

5

Hey @Lakshya_Garg,

You can use the linq method that I have shared previously.

Thanks,
Sanjit

6

I try but it’s not working

7

@Lakshya_Garg can you share your excel file and the expected output, I will write the solution and share with you

8

pivot data.xlsx (13.8 KB)
here is the file

9

PivotExample.zip (33.3 KB)
@Lakshya_Garg , you can use the below code for pivot.

10

Hi @Lakshya_Garg

Have a look on the thread

Go ahead to read official documentation

Regards
Gokul