Use Case:
I'm trying to replicate a calculation I use in Tableau for Invoices with multiple lines. I need Alteryx to only reflect the grand total amount based on a column and not based off the invoice line amount.
So if invoice #123 grand total is $5,125.95 and I have different 5 products (at different prices), I'd like to reflect only the grand total amount , rather than the summation ($5,125.95 ) five times and inflating the invoice amount to $25,629.75.
Here's the calculated (formula) field I'm using in Tableau to accomplish this:
{FIXED [Inv #]:MIN([Invoice_Total])}
| Invoice # | Product | Invoice Line Amount | Invoice Total |
| 123 | Air Pods | $ 249.99 | $ 5,125.95 |
| 123 | Monitor | $ 699.99 | $ 5,125.95 |
| 123 | Apple Mouse | $ 75.99 | $ 5,125.95 |
| 123 | MacBook Case | $ 99.99 | $ 5,125.95 |
| 123 | iPhone 20X | $ 3,999.99 | $ 5,125.95 |
