Alteryx Designer Discussions

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

Calculating sum total and percentage

SCK
8 - Asteroid

Hello all - I need another help. I need to calculate total of the dataset and then percentage of total only for a dataset with over 100 clients together. Please help.

 

Input:

ClientClient NumberDataData1Data2
A1Cash350
A1Accounts Payable4110
A1Accounts Receivable5250
A1Inventory & COGS6200
B2Cash7150
B2Accounts Payable885
B2Accounts Receivable990
B2Inventory & COGS10

110

 

Output:

 

ClientClient NumberDataData1Data2Ratio
A1Cash350 
A1Accounts Payable4110 
A1Accounts Receivable5250 
A1Inventory & COGS6200 
A1Total 186100.029508197
B2Cash7150 
B2Accounts Payable885 
B2Accounts Receivable990 
B2Inventory & COGS10110 
B2Total 7016550.042296073
1 REPLY 1
Assaf_m
11 - Bolide

Check the attached solution,

 

let me know if it works for you

 

Assaf_m_0-1618227171929.png

 

Labels