% of contribution
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 ?