Cost Benefit Analysis on Data in Alteryx

Question

I want to determine the optimal criteria (e.g., Tax > 500) to review the minimum number of invoices required to reach $2,000,000 in tax paid. Is it possible to perform this analysis with a tool in Alteryx? Than

Example of Cost/Benefit Analysis:

* Vendor 1 – Tax > 0 – $1.26M, 84 Invoices
* Vendor 1 – Tax > 500 – $1.25M, 39 Invoices

Remove 45 invoices at a reduction of $11K in tax paid.

Thank you!

Book2.csv

kona23 · Answer

Hi Qiu - thanks for the response. I am looking to determine the combination of vendors that reaches $2M with the lowest amount of total invoices across the vendors.

Qiu · Answer

@kona23 
It is per vendor? I dont see any vendor has reached 2M.