cancel
Showing results for 
Search instead for 
Did you mean: 

Groupby/Max Crop Data

SOLVED
Highlighted
Himal
Meteoroid

Hi All,

 

I have a data set showing the crop stats for 4 yrs. I want to groupby area, item, element and year and do sum on value. Then I want to transpose the year and find the maximum of all four years. I am attaching the screenshot of how my data should look at the end. Also attaching the sample data.

 

Screenshot_5.png

 

 

 

Thanks, 

Himal.

Bharti
Alteryx Certified Partner

hi @Himal,

i am attaching the solved workflow. i hope that helps.Screenshot (148).png

ponraj
Asteroid

solution.PNG