Last month of revenue

[Jan_L]

Hi,

I am kind of new to Alteryx and stucking with below challenge:

I have a table with revenue by client for each month of a year. Now I want to inlude a column which gives me the last month with revenue (so last column in below example):

Client	01/20	02/20	03/20	04/20	05/20	06/20	07/20	08/20	09/20	10/20	11/20	12/20	Last month of Revenue
A	5	5	5	5	5	0	0	0	0	0	0	0	5
B	2	0	2	0	2	0	2	0	0	0	0	0	7
C	4	4	0	0	0	4	4	0	0	0	4	4	12

Hope you can help?

Thanks in advance!

Jan

[ydmuley · Accepted solution]

Hello @Jan_L 

Please find attached the potential solution.

Do let me know if this helps.

Regards,

Yug

[Jan_L]

Great, thanks for the quick help!