Sum column except for the own row

My problem is trying to create a summation of the entire column except the row itself...

For instance, if I have a list of states and sales, I want to to be able to see how all of the other states combined are doing against itself like in the third column below.

State	Sales	Other State Sales Total
Arkansas	50	370
California	200	220
Texas	15	405
Washington	95	325
Tennessee	60	360

I cannot for the life of me figure this one out.

Workflow

Reporting

Accepted answers

pedrodrfaria

Hi @jbe0230

Please see attached for the solution to your question.

Pedro.

Sum column except for the own row.yxmd

All comments

ChrisTX

Sounds like you want a column for Percent of Total Sales. See attached workflow.

Percentage of Sales.png

Chris

Percentage of Sales.yxmd

pedrodrfaria

Hi @jbe0230

Please see attached for the solution to your question.

Pedro.

Sum column except for the own row.yxmd

apathetichell

You might be overthinking this. You have the total sales. You have the individual sales by state. Just subtract the individual state from the total.

Input. Summarize the total. Append it. Fomula for a new field to subtract out each state's entry from the total. Voila. Not sure how to post workflow pictures but I've attached a screengrab.

2021-02-11.png

jbe0230

This is perfect! Thank you!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317