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

Sum Only Locations with Sales in Each Month

lchart
5 - Atom

Alteryx User World,

      Newbie here, basically I'm trying to remove locations if they don't have sales in each month and then sum the sales for each location that meets the monthly requirement. Trying to go from what you see in the sample raw data to the summarized version below. 

 

Any and all help is appreciated! 

 

Raw Data:

Capture.PNG                 Desired Result    Capture2.PNG

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hello @lchart ,

 

Would this work for you?

 

Regards

lchart
5 - Atom

Beautiful! This is just what I was looking for. Thanks for the quick response. 

Labels