Need count to work dynamically depending on the list size
Hi,
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
Answers
-
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.
0 -
Sorry I don't quite understand your request. Do you want to count the details added to the order?
0 -
This content has been removed.
-
Replace "List" with the name of your line item. This formula will generate sequential numbers starting from 1 based on the order of the line items. It will dynamically adjust as you change the dimension values.
Best,
0