heretolearnexcel
Board Regular
- Joined
- Jan 22, 2019
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
I want total sales for each sku in a specific date range. But what I get is daily sales excluding the daily sales that are not in the date range. So I then group the daily sales into years, so that I only get the total yearly sales for each item, and I get this.
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
But this way I will still have to sum the total sales in 2018 and 2019 for each sku. What I want is to get total sales in the date range, not broken down in years or whatever. Like this:
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
How can I achieve this?
Note: the grand totals are irrelevant because I don't want the total sales of all the items, only the total sales of each item.
J | K | L | |
---|---|---|---|
4 | DATE | SKU | SALES |
5 | 2018 | A | 10 |
6 | B | 20 | |
7 | C | 35 | |
8 | D | 10 | |
9 | E | 15 | |
10 | F | 12 | |
11 | G | 13 | |
12 | H | 6 | |
13 | I | 7 | |
14 | 2019 | A | 5 |
15 | B | 9 | |
16 | C | 13 | |
17 | D | 23 | |
18 | E | 12 | |
19 | F | 15 | |
20 | G | 19 | |
21 | H | 12 | |
22 | I | 13 | |
23 | Grand Total | 249 |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Tabla Dinámica
But this way I will still have to sum the total sales in 2018 and 2019 for each sku. What I want is to get total sales in the date range, not broken down in years or whatever. Like this:
O | P | |
---|---|---|
4 | SKU | SALES |
5 | A | 15 |
6 | B | 29 |
7 | C | 48 |
8 | D | 33 |
9 | E | 27 |
10 | F | 27 |
11 | G | 32 |
12 | H | 18 |
13 | I | 20 |
14 | A | 254 |
15 | B | 9 |
16 | C | 13 |
17 | D | 23 |
18 | E | 12 |
19 | F | 15 |
20 | G | 19 |
21 | H | 12 |
22 | I | 13 |
23 | Grand Total | 619 |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Tabla Dinámica
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
How can I achieve this?
Note: the grand totals are irrelevant because I don't want the total sales of all the items, only the total sales of each item.