How to create pivot table and drag the fields in the boxes

Help
1

How to create pivot table and drag the fields in the boxes

2

@venkateshtangudu,

You can use the existing activity to create a pivot table. Before that, you need to create a data table with the required columns in it.

Or else, you need to write VB code to do that

3

Hii,

Can you send me any sample pivot table and data table with any columns in it

4

You want it with existing activities or code?

1 Like
5

hii,

existing activity…if possible code too

6

Here is the best example for creating pivot table @venkateshtangudu,

Create Pivot Table.zip (19.3 KB)

Check this link for code to create a pivot table :

2 Likes
7

thanks i will check

8

Sure…

Let me know if you have any doubts and make sure your excel data is in the tabular format and has the table name . Then you have to give that table name in the create pivot table activity

9

hii,

i understood, can we drag the pivot table fields…!in filter,columns,rows and values automatically

pivot
pivot1920×1080 209 KB

1 Like
10

Existing activity will take them based on the data types but you can do that using code.

Check the code. It has everything and let me know if you have doubts

1 Like
11

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