I am making this simple macro to make a pareto analysis (80/20).
It's supposed to import a dataset and select the items analyzed, their sales, and overlays the profits. This part is fine.
Down in the metro I want the cutoff to be changed using another control parameter that connects to the filter tool. So the user can at the beginning of the macro change the cutoff to study 50% or 80% or 90% (not neccessarily the 80% from the 80-20 rule).
The second control parameter is defaulted to 80%, but when the macro is saved and run in a regular workflow it says "cannot find connection", and any change to the number still results with the analysis done at 80%, i.e the default value. What am I missing here?
