Help with AutoNumbers scripting

[mikelees80]

So I have table containing a list of products per customer and a status

What I want to is count by status and customer by wanted a rolling total.

Example Raw Table

AccountKey	Cumulative	InstallDate	Number	Category	CategoryFull	CategoryPEO
96609|PANTHER	1	10/27/2013	4397205	FULL	4397205
96609|PANTHER	2	1/26/2014	4397593	FULL	4397593
96609|PANTHER	3	4/27/2014	4577138	FULL	4577138
96609|PANTHER	4	6/28/2015	5117108	PEO		5117108
131542|PANTHER	1	11/22/2015	5160542	FULL	5160542
131542|PANTHER	2	10/23/2016	9294480	PEO		9294480

Required result

AccountKey	Cumulative	InstallDate	Number	Category	CategoryFull	CategoryPEO	FullCount	PeoCount
96609|PANTHER	1	10/27/2013	4397205	FULL	4397205		1	0
96609|PANTHER	2	1/26/2014	4397593	FULL	4397593		2	0
96609|PANTHER	3	4/27/2014	4577138	FULL	4577138		3	0
96609|PANTHER	4	6/28/2015	5117108	PEO		5117108	3	1
131542|PANTHER	1	11/22/2015	5160542	FULL	5160542		1	0
131542|PANTHER	2	10/23/2016	9294480	PEO		9294480	1	1

I've been trying to use AutoNumbers   but I couldn't get it do work

autonumber(alt(Number,'NA'),AccountKey)-1 as Serial

,autonumber(alt(CategoryFull,'NA'),AccountKey)-1 as SerialCategoryFull
,autonumber(alt(CategoryPEO,'NA'),AccountKey)-1 as SerialCategoryPEO

example

AccountKey	Cumulative	InstallDate	Number	Category	CategoryFull	CategoryPEO	SerialCategoryFull	SerialCategoryPEO
96609|PANTHER	1	10/27/2013	4397205	FULL	4397205		1	0
96609|PANTHER	2	1/26/2014	4397593	FULL	4397593		2	0
96609|PANTHER	3	4/27/2014	4577138	FULL	4577138		3	0
96609|PANTHER	4	6/28/2015	5117108	PEO		5117108	0	4
131542|PANTHER	1	11/22/2015	5160542	FULL	5160542		1	0
131542|PANTHER	2	10/23/2016	9294480	PEO		9294480	0	2