This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Running Total on the Transform menu will add up your column from row 1 to the current row. You can then summarize by Max of running total. Rename the output column to match the name of your original column with 1s and 0s. To add the total as a row at the bottom of your data use a union tool with Auto config by name (important the name of your original column and the total from the summarise tool are the same).
However, unless you're outputting the data straight after this, and doing nothing else with it, I'd warn against adding the total as a new row at the bottom. Any further processing will treat it as just another number in this column and Alteryx won't distinguish it as a total.