Sumif or filter assistance

[AJ_AJ]

Hi There,

I have an situation where in with my huge Data I would like to work on population that does not net to 0. ( In other words I would like to exclude the once that net to 0)

Example I have attached below.

IF you see the example, in that case A and C Net to 0 while others don't. Hence I would like to proceed further without A & C's information.

I have around 10000 rows and 53 column information in my actual data.

I want the A&C information to be vanished on all 53 columns.

[jdunkerley79 · Accepted solution]

I would suggest:

First, create the totals (using a summarize)

Then filter out the 0s

Then join back to the original set.

The J connection will be the filtered set