Incremental Month Count From First Month

[MalcolmCICWF]

I have yet to be able to find a solution to this out there. I am trying to create a pivot table of incremental months starting at the first month. There is a record for each month the Example1 has existed... But, Example2 could start at a different month depending on when it was purchased. I want to, for each Example, have the initial month be 1, but continue to count each month that the Example exists. 

In my Example1, it has existed for 16 months... but Example2 may have existed for 34 months... I am trying to figure out in the script how to create a field and label each month EACH example has existed. This point behind this is to show how much revenue has been brought in each month, not by actual MM/DD/YYYY, but by total months it has existed.

[Kushal_Chawda · Accepted solution]

@MalcolmCICWF  Assuming that you have example & month field available in data you can try below

LOAD *

.......

AutoNumber(Month,Example) as Number

resident Table

order by Example, Month;

drop table Table;

[MalcolmCICWF]

That simple huh? Never used that before, let me give it a shot and I'll report back

[MalcolmCICWF]

It indeed did work perfect for what I needed it for. thank you