How to pass variables to Pivot Table

Hi,

I am creating a pivot table using this process.

I have to create about 20 pivot tables. Is it possible to pass the info required for the 'Cross Tab' from a text file using micro, So I don't need to create 20 processes?

I am new to Alteryx and not familiar with micro. Any suggestions would be a great help. Thanks.

Kuha

Tips and Tricks

Accepted answers

martinding

Hi @Kuha,

Please see below:

I've set a relative path in the macro, but feel free to change it to your desired saving location in the formula tool.

Report Macro.yxzp

All comments

martinding

Hi @Kuha,

You can certainly build a Macro to help you automate this process.

Would you be able to provide a sample data set and your desired output so that we can better understand your use case?

Kuha

Hi,

I have attached a sample file as you requested.

Kuha

Test_Data_01.xlsx

martinding

Hi @Kuha,

Would you be able to shed some light on how the "Filter" works?

Are you trying to select a particular Field in each report? e.g. for Report-01, do you only want the region field? or are you selecting a particular value of region? e.g. you want the region to be east?