We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sum in one Column

akvsachin
8 - Asteroid

Attached are 2 snippets as well as excel sheets Input & Output.

Please help me with getting the sum in the same column.

 

Name IDCategoryCountry of IssueAmount
Sachin846572ReferigeratorIndia52
Mukesh953274TVIndia96
Suresh846572GroceryIndia63
Kane623958Football MatchUS52
Lily 232654Cricket Stadium US15
Ashish232654Online ShoppingIndia85
Harsh953274Laptop & AccessoriesIndia74
Kunal846572Gaming ConsoleIndia95
Sridhar953274Match Arena TurfUnited Arab Emirates12
Anjali953274Electonics EquipmentIndia95
Gavi846572ReferigeratorSpain84
Pedri623958TVSpain91
Benzema846572GrocerySpain97
Marcelo846572Football MatchSpain93
Antony623958Cricket Stadium Brazil51
Sujeet623958Online ShoppingIndia12

 

Output:

 

Anjali953274Electonics EquipmentIndia95
Harsh953274Laptop & AccessoriesIndia74
Mukesh953274TVIndia96
Sridhar953274Match Arena TurfUnited Arab Emirates12
 953274  277
Benzema846572GrocerySpain97
Gavi846572ReferigeratorSpain84
Kunal846572Gaming ConsoleIndia95
Marcelo846572Football MatchSpain93
Sachin846572ReferigeratorIndia52
Suresh846572GroceryIndia63
 846572  484
Antony623958Cricket Stadium Brazil51
Kane623958Football MatchUS52
Pedri623958TVSpain91
Sujeet623958Online ShoppingIndia12
 623958  206
Ashish232654Online ShoppingIndia85
Lily 232654Cricket Stadium US15
 232654  100
    1067

 

 

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

This seems to be a duplicate post: Sum in One column - Alteryx Community

Labels
Top Solution Authors