[Ask] How to use the "create pivot table" activity?

Hi All,

I’m trying to use the activity called “create pivot table”
But when i use this activity, the uipath robot are put all the column/header inside “rows”
how to automatically define which column goes to the “values” and make it as “sum” rather than just “count”

seem the activity only have limited function, if i need to use VBA then I better put all my codes in VBA rather than using RPA

the activity option, and the excel result

Thanks,
Indra

See this

Thanks,
Prankur