% of Total Sales Column Add

leonardschlemm
leonardschlemm βšͺ️
edited February 24 in Dataflows

Hello All,

New to Domo and appreciate the community support.

I have a table card that includes net sales by cashier listed for the day in descending order. I would like to add a column that shows their sales as a % of total sales for the day.

How would I do this ?

Thanks !

Best Answer

Answers

  • swagner
    swagner 🟒

    Try this:

    If the Sales beast mode is SUM(`Sales`), then the % of Sales beast mode would be:


    SUM(`Sales`) / SUM(SUM(`Sales`)) OVER()

  • thanks for quick response. how would i reference the cashier in this function ? the cashier data line is a dimension

  • Thanks !