Problem related to creating Pivot table by passing more than one row, column and value fields

Help Activities
, ,
1

Hi All,

I have encountered one problem where i have to create a pivot with two Row values ( Row name in my case are “GL Desc”, “LineDescr”) one column value (in my case it’s “Nature”) and one value field (“Net Amount”).
I have attached the sample input and output workbook, please review and suggest some solution.
PivotforUipath.xlsx (38.2 KB)

3

Hello Gunjan,
Maybe this code will help.
Here I have a Video with code of how I create Pivot Tabel:

Code:

Thanks,
Cristian