Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Groupby/Max Crop Data

Himal
6 - 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.

2 REPLIES 2
bharti_dalal
10 - Fireball

hi @Himal,

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

ponraj
13 - Pulsar

solution.PNG

Labels