EXCEL: Only show Data from the Previous month (Sort Descending-no zeros)

[neromerob]

Hello to everyone.

I have a table showing information of several month including the current one

But I need to get ONLY the information regarding the previous month without considering the rest, and also not considering when the month is showing zero values, Sort Descending.

My problem is because the month changes I don’t know how to do it, this should be dynamic.

The output should look like this.

I add a sample table for your consideration (with the rest of the months including the current one). 

Thank you so much. 

[DataNath]

Are there months in your data where all rows are 0 @neromerob? If so, I think I misunderstood the ask as I filter these out to only show the most recent with non-0 values. I've just tested the flow a few times by taking off various final months and it always takes off the second most recent (that aren't full of 0s).

If you don't want to remove months if they're all 0 then this flow is an alternative.

[neromerob]

Hello @DataNath 

What i´m looking for is to get only the data from the previous month (in this case May) and showing only when the month is different from zero. And it should be dynamic for next "previous months"

[DataNath]

So you only want rows that aren't 0? If so the flow is below.

If you mean when the whole field is 0, then my earlier solution does that. The reason it will have jumped back to January is that will be the most recent previous month without all 0s.

[binuacs]

@neromerob I am not sure why you are getting different result. Can you check the attached workflow?

[neromerob]

hello @binuacs 

Now it seem to be working (I mean the previous month, and sort descending) but is showing the zero values. 

without the zeros would be ok. 

Thank you for your time. 

[neromerob]

hello @DataNath 

The result that you show is the one that I need, although the workflow that is attached still how me January. 

Sorry for the inconvenience 

[DataNath · Accepted solution]

Hmm really not sure what's going on as it works fine when I test taking months off to check it's dynamic. Is this any better?

[binuacs]

@neromerob updated the workflow by adding a filter tool to remove the zero values

[neromerob]

The last solution provided by @DataNath seems to be working, a big thank you to him and to @binuacs  and @kathleenmonks  for your insight in this issue.