Filter Grouping By Step

[Anonymous]

I want to proceed with grouping the Amount column (by SUM) based on Month column by filtering out the Invalid entries from the Validity column first, so, we should end up having:

• January: 3000.
• February: 5000

How to accomplish this filtration thing in the grouping step please?

[AbbasG]

@Anonymous I may be wrong, most of the time I am :), but I don't think that filtering is possible with the grouping step.

However, you can do grouping by validity and month and simply filter by validity to get your desired output. 

Hope this helps, if you have any better option I am all ears!

[Anonymous]

I need all entries, so, no, filtering out before grouping does not solve that scenario.