Create Pivot Table Help request

Hello,
I am using create pivot table ı have dynamic field that ise “AKTIF_SIGORTALI_ADET”, “BRUT_PRIM”, “KAZANILAN_BRUT_PRIM” these are my columns and i want to dynamic field ı want to sum values how can ı that? Rows is changeable.I have different excel pivot table

Hi @sedayngl_sedayngl33

Are you trying to do this manually like from excel or looking to use UiPath to do such operation?

Hi @sedayngl_sedayngl33

try to use create pivot table in UiPath, then loop through your dynamic fields (lik- aktif_sigortali_adet, etc.) and use add data field with datafieldfunction.sum for each. rows can also be set dynamically from a list.I’m no much sure but pls try.

Happy Automation

can u show details i didnt find add data field?

I show sample output ı want to make in UiPath studio