desserts
21994
16565
7615
25231
noodles
7147
12078
18756
pasta
29886
14290
5474
8239
17492
salads
8731
12539
14732
6739
13626
sandwiches
13009
22867
7207
7107
seafood
15133
7965
7438
8917
14820
soups
11528
9314
9946
INPUT 1
Country, food types
Country, food types
Warn
transpose country columns to rows
countries back to columns + calculate total row/column
countries back to columns + calculate total row/column
Basic
100%
Total
Always
Data
==
1
1
TotalColumn
Simple
Data
Food Item
==
Total
1
TotalRow
Food Item
Simple
Data
Food Item
==
Total
1
TotalRow
replace "Total" row/column labels + format total row
Basic Table
Remove
Prefix
Sum_
Ignore
remove prefixes
remove prefixes
C:\Users\ROLAND~1\AppData\Local\Temp\Engine_26092_e5552b7a0e8848eba1db21204685bd1c_\Engine_6928_c56d1067b94a41d3843402efc30bb23e_.yxdb
Single
Report
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Horizontal
challenge_324_solution_rsc