SUM a dimension and then filter?

[pupmup]

Hello!

I have data in the following format:

Values	Date
0	1/1/16
3	1/1/16
9.3	1/1/16
0	2/1/16
0	2/1/16
1	2/1/16
0	3/1/16
0	3/1/16

What I'd like is to SUM the data by date, and then remove any rows where the sum is 0 or less. So in the table above, all the rows with the date as 3/1/16 would be removed, as their sum is 0. All of the rows with a date of 2/1/16 (with a sum of 1) would remain. 

Can anyone please advise how to achieve this? I'm coming from Tableau and finding it hard to reconceptualise behaviour out of calculated fields.

[MarqueeCrew · Accepted solution]

@pupmup,

Here's a two-step process:

1. Summarize Tool:  Group by Date & Sum Values
2. Filter Tool:  Sum_Values > 0

That should get you what you want, dates with a positive value.

Cheers,

Mark

[pupmup]

Thank you very much! I did the same and it worked. But using the summarize appears to have aggregated all my data - I can no longer browse at row level. 

I'm going to try and join with the data from before the summarise, keeping only those rows that match the summarised date fields. 

Thanks again!