% of contribution

Adrien

Hi,

I try to build a card where I can view the individual contribution over the total from the sales leader, for the month and where we view each month of the year.

So I have a pivot table. Date view is This Year.

Row : Sales Leader, Reps

Column : Month

Value : Sales, Contribution.

Right now, I use this rule in my beast mode

SUM(`TOS`) / sum(SUM(`TOS`)) over ()

That work, but the contribution is calculated for the whole year and across every sales leader.

Is there a way I can have the contribution, by sales leader, by month ?

Thanks :)

GrantSmith

Hi @Adrien

You can use partitions in your window function:

SUM(`TOS`) / SUM(SUM(`TOS`)) OVER (PARTITION BY `Sales Leader`, `Month`)

jaeW_at_Onyx

https://www.youtube.com/watch?v=eifSYZIcPzg

i'll just leave this here.

GrantSmith

Hi @Adrien

You can use partitions in your window function:

SUM(`TOS`) / SUM(SUM(`TOS`)) OVER (PARTITION BY `Sales Leader`, `Month`)

jaeW_at_Onyx

https://www.youtube.com/watch?v=eifSYZIcPzg

i'll just leave this here.