Add field from field list to pivot table

[santi4058 (Santiago Alzate)]

Hi Everyone,

I wanted to know if someone could help me and know how to add the cycle field to the table:

And in the table see the field like this:

Thanks for the help

[Anthony_Humphries]

There is not a built-in way to do this, but you could create a table containing only the data you need and making the pivot table from that. that way the fields will be selected automatically.

[santi4058 (Santiago Alzate)]

Sorry for the inconvenience, how could I do that?

[Anthony_Humphries]

There are a few ways, but the easiest one in my opinion is to use Read Range to read the specific information from your table in Excel, then Write Range to write it somewhere else in the workbook. Then use Create Table to turn it into an Excel table, and reference that table in your Creat Pivottable activity.

[HareeshMR (Hareesh Madasi)]

If you are willing to use VB here to do that, please refer the below post

Create pivot table with dynamic data source range in uipath

Here it is @mashy2, May be it is bit clumpsy, try to understand Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet excel = New Microsoft.Office.Interop.Excel.Application 'create the instance of excel work book' Dim p_ws As Microsoft.Office.Interop.Excel.Worksheet Dim rng As Microsoft.Office.Interop.Excel.Range 'capturing the range of qry_GS_Monthly_ProjRes ''…