cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Groupby/Max Crop Data

SOLVED
Highlighted
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.

Alteryx Certified Partner

hi @Himal,

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

Bolide

solution.PNG