How to start do pivot table using studio x community

[Nur_Amin]

hi
can anyone help on how i can start to do pivot table using studio x community?
this is my table

Product	RM	BM
A	30	45
B	49	8
C	45	9
D	76	76
E	4	8
F	6	9
A	6	1
B	47	2
D	4	4
D	6	6
F	5	89
D	6	6
D	47	47
G	8	8

[supriya117 (Supriya Allada)]

Hi @Nur_Amin

Check this:
https://docs.uipath.com/studiox/standalone/2023.4/user-guide/tutorial-creating-a-piv

[vrdabberu (Varunraj Dabberu)]

@Nur_Amin

Please use the below activity

Hope it helps!!

[Nur_Amin]

i use this but it appear error
this activity require at least one child activity to present

[rlgandu (Rajyalakshmi Gandu)]

@Nur_Amin

How to create pivot table with required fields?

Hi, CreatePivotTable activity will help you. Can you check the following documents? Regards,

[vrdabberu (Varunraj Dabberu)]

@Nur_Amin

You need to click on that and pass the data on what basis you want a pivot table.

Regards

[vrdabberu (Varunraj Dabberu)]

@Nur_Amin

Here in my case i have given BM value sum

and the output is like

Regards

[vrdabberu (Varunraj Dabberu)]

Thank You @Nur_Amin

Happy Automation!!