How to add new rows to a data set

[PPSS]

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

[atcodedog05 · Accepted solution]

Hi @PPSS 

Here is how you can do it.

Workflow:

Hope this helps : )

[saveeshkumar · Accepted solution]

Hi @PSS,

Please find the flow.

thanks

[atcodedog05]

I agree, @saveeshkumar method is much eaiser and has less steps for this usecase 🙂

[PPSS]

Thanks a lot, very helpful:)

[PPSS · Accepted solution]

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

[saveeshkumar]

Hi @PPSS ,

You need to add two dummy columns in formula and summarize tool..

Thanks