Sum Total of Date Range in Pivot Table

heretolearnexcel

New Member
Joined
Jan 22, 2019
Messages
26
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.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,095,170
Messages
5,442,799
Members
405,198
Latest member
Florence Thomas

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top