Dear Community,
I have a simple mockup workflow with two input files:
Trade Data – containing trading countries, commodities, and trade values.
Tariff Rates – containing trading countries and their respective tariff rates.
I have a Python script that successfully calculates the trade-weighted average. However, I want to add a dynamic filter (list box) that allows users to select countries (and eventually commodities) to run the calculations on a smaller subset of data.
The issue is that I can't get this filter to work correctly. I believe I need to crosstab the data so that the list box can recognize it, and then pass the updated selection to Python. However, I’ve been struggling with this for days.
Can anyone help me locate the error and find a solution?
Thanks in advance!
Dustin
