Define Row and value on Pivot table activities

jackyaa1 · September 1, 2021, 1:03pm

Hi, could I define row and value on uipath pivot table activites?
I used the create pivot table activites to create pivot table, but the output sum the inovice number, date… it’s not expected results. How do i define row and sum value on uipath?

lakshman · September 1, 2021, 1:06pm

@jackyaa1

Please check below thread to know more about Create Pivot Table activity.

jackyaa1 · September 1, 2021, 1:10pm

Thank you, lakshman,

I have read this docs before. But it seems this doc is about StudioX. I don’t find this activity " `UiPath.Excel.Activities.Business.CreatePivotTableX" on Studio Pro…

lakshman · September 1, 2021, 1:17pm

@jackyaa1

Sorry. I thought you are looking for StudioX.

In Studio activity, we don’t have any option to define row and all.

jackyaa1 · September 1, 2021, 1:23pm

Is there any work around, such that I can define row and column on UiPath? Do vba is the only way?

moenk · September 2, 2021, 6:27am

VBA is not just the only, but also the best way to do specific pivot tables. There are so many options besides just creating a pivot so that I prefer to code this in VBA and call that from UiPath.

Cristian_Negulescu · November 25, 2021, 7:19pm

Hello JackY,
Here I have a Video with code of how I create Pivot Tabel:

VBA Code:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/VBAFile.vbs

Sub MyVBA()

Set PSheet = Worksheets("Rez2")
Set DSheet = Worksheets("Test")

'Define Data Range
LastRow = DSheet.Cells(Rows.Count, 1).End(xlUp).Row
LastCol = DSheet.Cells(1, Columns.Count).End(xlToLeft).Column
Set PRange = DSheet.Cells(1, 1).Resize(LastRow, LastCol)


'Define Pivot Cache
Set PCache = ActiveWorkbook.PivotCaches.Create _
(SourceType:=xlDatabase, SourceData:=PRange)


'Insert Blank Pivot Table
Set PTable = PCache.CreatePivotTable _
(TableDestination:=PSheet.Cells(1, 1), TableName:="RezPivot")
PTable.ClearTable

This file has been truncated. show original

Thanks

Most Active Users - Yesterday
Anil_G
mpraveen1902
Palaniyappan
Yoichi
tazunnisa.badavide
Nguyen_Van_Luong1
Carla_Munoz
ayushi_jain3
Parvathy
nikhil.girish
More details...