Please have a look at attached file. I need to create some calculated field which will show ordinal numer of records for each year. I used INDEX() function which is showing me how many records (orders) I have total, which is almost what I want. But when I added pill with YEAR - I would like to number in "ordinal number" column start counting from the beginning for each year. So for
2022: 1, 2, 3, 4
2023: 1, 2, 3
2024: 1, 2, 3, 4
I was trying to use LOD (Exclude), but it did not worked.
Any idea how to do it?
@Michał Magin You need to edit the INDEX calculation on the sheet to restart every year. Click on the [Ordinal number] pill and select 'Edit Table Calculation'. Select 'Specific Dimensions' and uncheck 'Year of order date'.
James Emery
Tableau Forums Ambassador
Please click 'Select as Best' on the one reply that answers your question.
