Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Replicate Countits/Sumifs/Pivot from Excel in Alteryx

ducanhledao
5 - Atom
‎12-17-2020 06:37 AM

Hi Alteryx Community,

 

I would like to replicate the yellow highlighted formulas in Excel to Alteryx. Hope to receive your help. 

 

The tasks I need to do is highlighted yellow.  Here are the tasks:photo1.PNG Here are the formulas/Pivot table results in Excel I tried to replicate in Alteryx

photo2.PNG

 

Thank you for your help. I have attached the excel file if needed. 

 

 

 

Preview file
18 KB
Labels:
Reply
0 Likes
1 REPLY 1
echuong1
Alteryx Alumni (Retired)
‎12-17-2020 09:53 AM

This can be achieved with a series of filters and summarize tools. I'm not sure I understand what you're looking for with Task 3, but the general process applies. I've replicated tasks 1 and 2 in the attached example. The bottom stream is what I believe task 3 should be.

 

I also added a record ID and sort to help visualize the data a little better as you're working through the process, but these are not necessary.

 

echuong1_0-1608227570613.png

 

New Workflow1.yxmd
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All