Howto achieve this?

sanjujeeboy — Sat, 16 Nov 2024 02:26:15 GMT

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

Thanks.

Re: Howto achieve this?

chrismarlow — Thu, 19 Sep 2019 19:24:42 GMT

Hi,

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

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

Cheers,

Chris.