Making a pivot table using allocated amounts

Help Studio
, , ,
1

Hi!

How do I create the Pivot Tables using UiPath Studio (Not Studio X) which includes all the allocated amounts (Column W in Concur Data) and finds a grand sum of each month. The month sheets are dependent on the individuals Report ID, Name, and Date. Here is the excel sheet below. Thank you!

COPY 2021 YTD Weekly Billing Expense Allocation.xlsx (63.7 KB)

2

If you have to create Pivot Tables, Maybe you can invoke Excel VBA.
Or you can find unique item in ColumnA first.
Second, sum row(“Allocated Expense Amount”) if row(“Billing Period”).toString = each unique item. Then you can get your answer.

1 Like
3

@Pranav_KomandurPK
my solution.
Forum0608.zip (61.2 KB)

1 Like
4

image
image839Ă—518 99.7 KB

Hi,

I am getting this error I believe with the write range.

Thank you so much for the help

5

I think your worksheet name contain time Mark like , : /
check rowU(“Billing Period”).tostring

image

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.