Total at the top and blank repeating data

[kauser]

Hello,

i am trying to a pivot table in Alteryx and currently getting this output but want to see the output like on second table - 

Current Output- 

AC	Serial	$$
2345	56345	4,545.00
2345	56360	11,362.50
2345	31267	28,406.25
2345	31549	71,015.63
2345	34090	177,539.06
2345	39718	443,847.66
2345	39802	1,109,619.14
2345	101032	2,774,047.85
2345	111505	6,935,119.63
2345	[Null]	11,555,502.71	Total of 2345
7678	345346	567,567.00
7678	56456	34,543,543.00
7678	[Null]	35,111,110.00	Total of 7678
3457	456546	-
3457	[Null]	-
3457	23143	34,534,655.00
3457	[Null]	34,534,655.00	Total of 3457

Expected Output - 

AC	Serial	$$
2345	[Null]	11,555,502.71
	56345	4,545.00
	56360	11,362.50
	31267	28,406.25
	31549	71,015.63
	34090	177,539.06
	39718	443,847.66
	39802	1,109,619.14
	101032	2,774,047.85
	111505	6,935,119.63
7678	[Null]	35,111,110.00
	345346	567,567.00
	56456	34,543,543.00
3457	[Null]	34,534,655.00
	456546	-
	[Null]	-
	23143	34,534,655.00
Total		81,201,267.71

Thank you 

Kauser

[binu_acs · Accepted solution]

@kauser macro approach