% of Total Sales Column Add

Member
edited February 2021

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 !

• Coach

@leonardschlemm , what @swagner gave you is called a window function. this is a common implementation in SQL which can be googled!

assuming you have cashiers on the axis, you should be getting that cashiers sales as a percent of total sales.

if you want that cashiers sales as a percent of store sales or some other subtotal method, add a partition by clause.

```sum(sum(amount)) over (partition by `store`)
```

I have a couple videos on my channel on the topic.

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"

• Contributor

Try this:

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

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

• Member

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

• Coach

@leonardschlemm , what @swagner gave you is called a window function. this is a common implementation in SQL which can be googled!

assuming you have cashiers on the axis, you should be getting that cashiers sales as a percent of total sales.

if you want that cashiers sales as a percent of store sales or some other subtotal method, add a partition by clause.

```sum(sum(amount)) over (partition by `store`)
```

I have a couple videos on my channel on the topic.