In the accompanying data table, in the Totals column, I need to add up the Amount column for each instance of the combination of the Invoice and Payee columns being the same. Invoice A has the same Payee for each row, so those got added together. Same thing for Invoice B. Invoice C has 2 rows with the same Payee and 1 is different, so the 2 rows get totaled and the third is its own total. Invoice E has 3 the same and 1 different. How can I leave the data in its current order and yet do the Alteryx equivalent of Excel's SumIfs?
The formula in Totals looks like this: =SUMIFS([Amount],[Invoice '#],[@[Invoice '#]],[Payee],[@Payee])
Solved! Go to Solution.
Grazie! Grazie! I'll add a count column to put it back in it's original order.