Sales template
Revenue by Product Template
See which products drive revenue. Share of total updates as you add sales.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Product | Units | Price | Revenue | Share |
| 2 | Basic | 420 | 290 | =B2*C2 | =D2/$D$5 |
| 3 | Plus | 180 | 590 | =B3*C3 | =D3/$D$5 |
| 4 | Pro | 60 | 1,490 | =B4*C4 | =D4/$D$5 |
| 5 | Total | =SUM(B2:B4) | =SUM(D2:D4) | =SUM(E2:E4) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =B2*C2
Units sold times price.
E2 =D2/$D$5
This product's share of total revenue. $D$5 stays fixed when copied.
Make it yours by asking
Try a request like this in Tabstra:
"Create a revenue by product sheet with units sold, price, revenue and share of total revenue"