1 of 1 people found this helpful
I'm assuming that total pounds in District 24 should be 1.8 million. To get that on a text table, try filtering to pointID=1. This will grab the first row for each shape. You could also rearrange the data in Alteryx so everything comes through in one file. This would lead to duplicate rows (since you're adding the point data to draw lines) but you could filter after the fact.
Hope this helps!
Thanks Paul. I'm going to give that a shot, and I'll update with results!!
I'm using CalcFields with this convention - If PointID=1 THEN [0-2 Duplicated] END. This is working great for giving me the numbers I need in the text table. Thank you. Couple other questions:
1) How can I get those numbers to total using the grand total under Analysis | Totals? All the calcfields are on the row shelf as discrete SUMs.
2) How can I get these to show in the tool tip on the map? They're rendering blank.
Thanks again. I feel I'm 'this close!'.