Howto achieve this?

[sanjujeeboy]

Hi

I have a below table.

My requirement is to have a column where it calculates %share of each week for monthly revenue

eg for W1 what is %contribution for revenue for Jan. etc

WeekNumber	Monthtest	Yeartest	Revenue
			252866029.35
W1	Jan	2018	23927821.28
W2	Jan	2018	30333474.33
W3	Jan	2018	26330783.31
W4	Jan	2018	44499831.38
W5	Feb	2018	25113792.35
W6	Feb	2018	18856130.95
W7	Feb	2018	21004771
W8	Feb	2018	62799424.75

Thanks.

[chrismarlow]

Hi,

Depending on exactly how your fields are set up, something like;

sum(Revenue)/sum(Total <Monthtest, Yeartest> Revenue)

Cheers,

Chris.