Adding total row

[Mostafa_Anwar]

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.

[T_Willins]

HI @Mostafa_Anwar,

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.

[Mostafa_Anwar]

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

[T_Willins · Accepted solution]

Hi @Mostafa_Anwar,

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

[Mostafa_Anwar]

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