Month against month comparison

[sriku]

Hi All,

Need a help here!!

Here, 0 means "New" and 1 means "Existing"
For the month of Feb it need to be compared against Jan,
similarly, March against Feb, April against March and so on and bucket as "New" or Existing"

Example,
For the month of Feb compared against Jan we can see 2 are "New" and 4 are "Existing"

Output

Thanks in advance.

Regards,

Sriku

[CharlieS · Accepted solution]

After a little formatting with a Dynamic Rename and a Filter tool, I used a Multi-Field Formula and a Transpose tool to produce the request output.

Check out the attached example and let me know if that works for you.