Creating pivot with classic activities with required fields

Help Studio
, ,
1

Hi Team,
please help me ,Is there any way to creating Pivot Table with required fields using classic activities, I have built it easily with Modern activity but in execution it takes too much of time and my team also prefer classic activities only.

2

@Naveen_Kumar6

these are the classic activities

A list of table-related options in a software application, including actions like creating, filtering, sorting, and editing tables and pivot tables. (Captioned by AI)
A list of table-related options in a software application, including actions like creating, filtering, sorting, and editing tables and pivot tables. (Captioned by AI)447×253 3.69 KB

cheers

3

but there is no options for select required fields,like modern.

An interface for creating a pivot table in Excel, featuring fields for source data, table name, destination, and a button to add pivot table fields, with the button circled in blue. (Captioned by AI)
An interface for creating a pivot table in Excel, featuring fields for source data, table name, destination, and a button to add pivot table fields, with the button circled in blue. (Captioned by AI)510×324 14.5 KB

4

Hie @Naveen_Kumar6 you can create pivot table with Classic activities but they have limited sets of activities.i think you want to do some filter and all other steps in the pivot too. i so the alternate method is too go with modern or else use VBA script inside excel application scope activity.
cheers

5

@Naveen_Kumar6

Yes that is the reason it is improved in newer modern version to include more customization

if you need customization like that and dont want to use modern then better go with writing a macro and invoke it

one way to use classic

create a range with only required columns

then use filter table activity for filters etc…

few are possible nut not all

cheers