dived by Calculate Row data

[Anonymous]

I have below table and I want to add another filed % with EACH month Net revenue value should be divide by other row

"Month" and "GL name" are dimension and cost is calculated field

Please help me to get create formula

Month	GL Name	Cost	%
Nov	Custom brokers	-1.22	it should be like -1.22/-0.99
Nov	Warehousing	-5.59	-5.59/0.99
Nov	Duty	-9.6
Nov	Freight outbound	-27.65
Nov	Freight inbound	-2.11
Nov	Logistic overhead	0.00
Nov	Net Revenue	-0.99
Dec	Custom brokers	-1.54	=-1.54/-0.46
Dec	Warehousing	-5.45
Dec	Duty	-14.49
Dec	Freight outbound	-27.65
Dec	Freight inbound	-1.88
Dec	Logistic overhead	-0.01
Dec	Net Revenue	-0.46
Jan	Custom brokers	-1.42
Jan	Warehousing	-5.48
Jan	Duty	-14.95
Jan	Freight outbound	-24.18
Jan	Freight inbound	-2.31
Jan	Logistic overhead	-0.50
Jan	Net Revenue	-0.84
Jul	Custom brokers	-1.67
Jul	Warehousing	-5.80
Jul	Duty	-18.18
Jul	Freight outbound	-23.69
Jul	Freight inbound	-2.80
Jul	Logistic overhead	-0.07
Jul	Net Revenue	558.20
Total		357.66

[anbu1984]

Try this

=Sum(Cost)/ Sum(TOTAL Cost)

[JonnyPoole · Accepted solution]

Combination of TOTAL and SET ANALYSIS:

sum(Cost)

/

sum(  {$<[GL Name]={'Net Revenue'}>}  total <Month>  Cost)

I added some sorting and background shading to help you .

[Anonymous]

Thanks Jonathan Poole. It works well

[JonnyPoole]

Thanks for the note. Kindly close out the thread marking 'correct' or 'helpful' .