concatenate(
"0000",
COUNT(
FILTER(
"Purchase Item",
[Item]=[_THISROW].[Item]
)
)+1
)
when ever i delete older data and i update an active row , Because it has a count formula the value keeps changing. How do i make sure the value does not change every time i update the row
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |