Need count to work dynamically depending on the list size


I have a requirement where in a module i have 4 dimensions (2 as page filter, 2 in the rows), Also line items are on column. (No time as dimension)

I need to have a formula where it should reflect count of the line item starting from 1 to as many as the line item count is. And this should be dynamic based on the dimensions values i change. (It should always start from 1 and go till the line item count)

Any suggestion on this ? @JaredDolich

Thank you


  • Can you be more precise? Do you mean you want to count the line items added? A picture of what you want to achieve will be helpful to make the suggestion.