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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I applaud you for the work you've done. You're very close! I would suggest naming all of the fields in your totals row the same as the rest of the data stream (e.g. the value total will go in the Store field, the sum of January will go in the January field). That way, when you use the union tool, all of the fields will be matched up correctly automatically. Finally, you'll want to ensure in your union tool that the order is specified that your data stream is first then your total row.
Thanks -- I'm not a batch macro expert yet --- however, I was able to create a total per fund -- however when it create the file document it excludes the Total Row........ It displays correctly on the canvas but on the actual file created does not create the "Total" row.