Adding total row

Hi All,

i want to add a new row called total under sector column and summing all rows (Plan,Sales,Qty) per each product except Retail sector.

therefore total will summing (Education + Government + No Sector) without Retail

Please check the attached dataset.

Workflow

Accepted answers

Updated workflow with this information. My Qty amounts don't tie to your example as you indicated you wanted to exclude Retail.

Total Row.JPG

You may want to update descriptions so a user can tell what data has been excluded, but this workflow generates the answer you are looking for.

Total Row.JPG

Thanks @T_Willins for your respond, i want the total to be represent as per attached picture

Summing Pic.jpg

Updated workflow with this information. My Qty amounts don't tie to your example as you indicated you wanted to exclude Retail.

Total Row.JPG

Thanks @T_Willins i have learned a lot from you, Much appreciated.