% of contribution

Adrien ⚪️
edited July 2021 in Charting


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 :)

Best Answers

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    Hi @Adrien

    You can use partitions in your window function:

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴
    Answer ✓
    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"