community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Need help with Multi Row Formula

Asteroid

HI All,

 

I have the following scenario :

 

I want to create 2 calculated columns , one % of US and one % of EMEA where for Group , it should calculate New/Total , Screened/Total , Called/Total.

 

GroupTypeUS% of USEMEA% of EMEA
ITTotal100 200 
ITNew8080/100100100/200
ITScreened60601002020/200
ITCalled4040/1001010/200
SalesTotal50 100 
SalesNew4040/503030/200
SalesScreened3030/502020/200

Sales

Called2020/50

10

10/200

Is there a way i can use multi row formula for this? if yes what would be the best way. any suggestions will be helpful.

 

Thanks

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @sr49ers 

 

I have a different approach for your problem.

 

See if one of the results fits your needs.

 

Approach.PNG

Cheers,

Highlighted
Alteryx Partner

I would be using Filters and Summarize, Multi-row could be dangerous when the dataset is larger.

 

I don't understand the TOTAL logic though, in USA Total = Screened+Called, in EMEA Total= ????

Alteryx Certified Partner
Alteryx Certified Partner

@cmcclellan 

 

I'm guessing he pulled out a sample of his data.

 

That would be the only logic reason.

 

Cheers,

Labels