SUM a dimension and then filter?

Question

Hello!

I have data in the following format:

ValuesDate01/1/1631/1/169.31/1/1602/1/1602/1/1612/1/1603/1/1603/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 Answer

@pupmup,

Here's a two-step process:

* Summarize Tool:  Group by Date & Sum Values
* Filter Tool:  Sum_Values > 0

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

Cheers,

Mark