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

Alteryx designer Discussions

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

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,

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