Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Best way to make a summary sheet for an excel file?

abragg0103
7 - Meteor

So I have a simple workflow that takes in a ton of data, filters and processes it, then outputs it. Perfect. But then i still have to open it and do my own sum function to find what I need. There are a ton of rows with varying values in the Quantity field. I want to know the sum of all quantities less than or equal 1 million, and I also want to know the sum of all quantities greater than 1 million.

 

I get a massive file every day that I run through this workflow, is there a good way to have a summary sheet that just tells me this so I dont have to sum them manually?

1 REPLY 1
Aaron_Harter
11 - Bolide

Hi @abragg0103,

 

You may want to use the Summarize tool to create an exception report and use this new data stream to create a summary file: 

4.PNG

Labels