Hi Gurus,

I’m working on building a simple demand forecast based on average sales over the past 12 weeks.

I need a column that simply displays sequential numbers like 1, 2, 3, ... for each row in my pivot — regardless of any grouping or the number of items.

I first tried using RCOUNT(1) to generate the sequence, but in the pivot table, it's calculating based on the number of items included in the Rows. For example, if 3 items are present in each row, it returns values like 3, 6, 9, instead of 1, 2, 3.

Then I attempted to extract the month and day from a date field (WeekStart) to new col (data calc), and applied