View the last value in grouped pivot table

marbr796

New Member
Joined
Aug 14, 2018
Messages
1
I have a pivot table setup with dates along the columns, and these dates can be rolled up via groups into weeks or month. When the data is rolled up, is there a way to display the value from the last date in the group? In the example below it would be 2107 closing soh and 80 days cover when week 34 is rolled up.

34
Row Labels
14/08/2018
15/08/2018
16/08/2018
17/08/2018
18/08/2018
19/08/2018
20/08/2018
21/08/2018
22/08/2018
23/08/2018
24/08/2018
25/08/2018
Demand
38
29
29
29
29
29
29
29
29
29
29
29
Supply
1245
Min of Closing Stock
1177
1148
1120
1091
1062
1034
1005
977
948
2165
2136
2107
Day's Cover
45
44
43
42
41
40
39
38
37
82
81
80

<tbody>
</tbody>

Any help would be appreciated with this
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,109,275
Messages
5,527,728
Members
409,785
Latest member
AdamPriest

This Week's Hot Topics

Top