Sumifs

The equivalent in Alteryx would be to use the Summarize tool, if you want to get the overall total for where Name = A, and Type = Property, add the Summarize tool, and use Group By Name, Group By Type and Sum Total. That will give you the totals of all names and types. Then Filter where the Name = A and the Type = Property.

This link might help too.. https://www.alteryx.com/alteryx-excel

Hope that helps.

smoskowitz

Hi @alia10 --

You will want to use the Summarize tool. You will Group by the Name and type and then Sum by Total.

Thanks,

Seth

alia10

Thank you all for you help! That was just part 1 of what my manager wants. I have a follow up problem, our real data includes all 50 states, and I need to figure out how to sum the data for each individual state for each entity for property.

Not sure if that makes sense. Please see the updated data.

Would i be making a formula for each state per entity?

Dummy Data.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703