Find average of 2 column using StudioX

Help StudioX
,
1

I have to create a pivot table
value:[amt1]/[amt2]

I can see “Pivot Field” in “Create Pivot Table” activity of Studiox, but how can i pass both the column names in the field of “Pivot Field”

2

Hi,

As per my knowledge there is no direct option in the to multiply fields in the create pivot table activity in studiox. But there is a work round like below.

We have to use write cell to insert formula eg: =A2/B2 and use auto fill range to apply the specified rows and later we can use that field to assign value to average in the create pivot table field option. please refer the below screenshot for reference. i hope it might help on your requirement.

eg:
image

image
image1089×259 9.37 KB

3

@kirankumar.mahanthi1
Can you please share the xaml file, that would be easy to refer

4

Hi,

i have created sample work flow. run and see if it helps your requirement.

PivotProcess.zip (60.2 KB)