How to add new rows to a data set

Question

Team,

I have a dataset where I have sales people name in rows and sales target achieved for different periods in columns.

I just want to add Mean, Median, Max and Min below the data for different time periods (All the things I need to add are in yellow in the attached excel.)

Kindly let me know how to do it.

Regards,

P

Alteryx_Doubt.xlsx

atcodedog05 · Accepted Answer

Hi @PPSS

Here is how you can do it.

Workflow:

Hope this helps : )

saveeshkumar · Accepted Answer

Hi @PSS,

Please find the flow.

thanks

PPSS · Accepted Answer

Thanks Saveesh, very helpful.

Quick follow-up. What if we had 2 more columns say Salesperon region and designation (these 2 new columns to the right of salesperson name and left of sales achieved). So, basically the new columns will not have any mean/median /max etc. Will the below flow still work or will I have to tweak it a bit?

Regards,

PS