Country by Country report

[HNathoenie]

Dear all, 
I need to create a workflow for our country-by-country (transfer pricing) report. Does anyone have an example? 

Many thanks, 

[Luke_C]

Hi @HNathoenie 

You'll need to provide a lot more information. It's best if you have a specific question about functionality in your workflow (i.e. how to create a formula to replicate something in a legacy Excel file, how to filter data, etc). Most people here will not be able to share a full transfer pricing workflow with you as companies tend to frown upon sharing their work product publicly. 

[mahadevaswab]

Dear All,

Any one else have have transfer pricing related workflow for reference or can you advise guide us on the Transfer pricing workflow creation.

[Luke_C]

Hi @mahadevaswab 

TP workflows are likely going to be very specific to your organizations TP policy and footprint. There are some general similarities but having done several of these they are all a bit unique. I spoke a bit about this on a user group call a few months ago you might reference:

https://community.alteryx.com/t5/Central-Europe/Recording-UG-15-meeting-11-12-2024-6pm-CET/m-p/13493...

[OTrieger · Accepted solution]

@HNathoenie and @mahadevaswab 
As @Luke_C mentioned it is vert hard to assist you with the amount of data in your question.

But I'm assuming that all the data is coming from one source of data, to be able to generate different reported to different countries create one WF and then bundle it into a Batch Macro. Your Control Parament will be Countries. Ensure to add the country name to the naming of the target file.

The above concept will create a WF that preparing pricing based on county and then save one file per one country.

The rest I'm leaving to you guys, as you have the data.