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.
I've been trying to figure out the answer to this query I have for a few hours now and have been unable to do so on my end. I start off by have my original input file (one worksheet with compiled data) written to a new file that is separated into worksheets by values in a specific field. I was able to do this using the Output tool properly.
I then want to take the data from that output and within each worksheet, sum the values of another specified field and have a sum total in the bottom of that field for each worksheet. The issue I'm running into is that the workbook that will be inputted weekly can vary as one week there can be 5 worksheets and another there can be 10 depending on what field values appear that week.
I thought about using the dynamic input and union tool, but that would've just brought be back to step 1.
The desired output I have from this workflow is just the file broken up into different worksheets within the same workbook based off that specific field with the sum total of another value appearing on the bottom. How can I achieve this? Thanks in advance!