AutoNumber(recno(),Ref) as Count how it is calcilating pls
TEST:
LOAD * INLINE
[
Ref, Amount, Date
ABC, 100, 01/01/2012
ABC, 100, 01/01/2013
ABC, 150, 01/01/2014
BCD, 200, 15/01/2013
BCD, 225, 15/01/2014
CDE, 300, 20/01/2014
DEF, 300, 06/04/2012
DEF, 275, 06/04/2013
EFG, 200, 08/08/2013
FGH, 225, 10/12/2013
];