I Have 1 Requirement as i need to Give an Sequence Num as Per the Items.
it Should Start From 1.
May be try this
Or using Peek() function
If(Peek('Item') = Item, RangeSum(Peek('Sequence'), 1), 1) as Sequence
But make sure to sort the data using Order by before you apply AutoNumber or Peek()
Retrieving data ...