Sum Total of Date Range in Pivot Table

heretolearnexcel

Board Regular
Joined
Jan 22, 2019
Messages
58
Office Version
  1. 365
Platform
  1. 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.
JKL
4DATESKUSALES
52018A10
6B20
7C35
8D10
9E15
10F12
11G13
12H6
13I7
142019A5
15B9
16C13
17D23
18E12
19F15
20G19
21H12
22I13
23Grand Total249

<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:
OP
4SKUSALES
5A15
6B29
7C48
8D33
9E27
10F27
11G32
12H18
13I20
14A254
15B9
16C13
17D23
18E12
19F15
20G19
21H12
22I13
23Grand Total619

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Tabla Dinámica

Worksheet Formulas
CellFormula
P5=L5+L14
P6=L6+L15
P7=L7+L16
P8=L8+L17
P9=L9+L18
P10=L10+L19
P11=L11+L20
P12=L12+L21
P13=L13+L22
P14=L14+L23
P15=L15+L24
P16=L16+L25
P17=L17+L26
P18=L18+L27
P19=L19+L28
P20=L20+L29
P21=L21+L30
P22=L22+L31
P23=SUM(P5:P22)

<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.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,214,525
Messages
6,120,052
Members
448,940
Latest member
mdusw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top