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.
Hey @Maheshp - there’s a few ways of doing this but I’d say the easiest is definitely just using the Crew Macros total macro. If you’re a frequent Alteryx user the Crew pack is always great to have around so worth getting it downloaded - link here: http://www.chaosreignswithin.com/p/macros.html?m=1
Once installed the totals macro gives you the option to output a totals column, row or both.
Absolutely @Maheshp - if you bring on a Summarize tool and use it to find the sum of that numeric field you want to total, you can then append this with the append tool to the bottom of your data set. Just configure it to append based on name after making a dummy 'Date' field. You may need to tick to append in a certain order and reconfigure that if the wrong input is coming out on top.
Have attached an example using the data shown in your picture:
No problem @Maheshp - if this solved your issue then feel free to mark it as a solution so others with the same problem can easily find it in future. If not, let us know what else you need help with and can try to help you further!
Are you able to provide a more comprehensive screenshot, or even better, your workflow? Even if you delete all sensitive data and just use mock data. It really helps to see the full situation as I can't tell exactly what you're asking from your last response. If you want to repeat what I've provided above across several sheets that you're bringing in then this is possible but again it'd be best to see how your workflow currently looks.