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.
[TABLE="width: 1243"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]34
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels
[/TD]
[TD]14/08/2018
[/TD]
[TD]15/08/2018
[/TD]
[TD]16/08/2018
[/TD]
[TD]17/08/2018
[/TD]
[TD]18/08/2018
[/TD]
[TD]19/08/2018
[/TD]
[TD]20/08/2018
[/TD]
[TD]21/08/2018
[/TD]
[TD]22/08/2018
[/TD]
[TD]23/08/2018
[/TD]
[TD]24/08/2018
[/TD]
[TD]25/08/2018
[/TD]
[/TR]
[TR]
[TD]Demand
[/TD]
[TD]38
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[/TR]
[TR]
[TD]Supply
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1245
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Min of Closing Stock
[/TD]
[TD]1177
[/TD]
[TD]1148
[/TD]
[TD]1120
[/TD]
[TD]1091
[/TD]
[TD]1062
[/TD]
[TD]1034
[/TD]
[TD]1005
[/TD]
[TD]977
[/TD]
[TD]948
[/TD]
[TD]2165
[/TD]
[TD]2136
[/TD]
[TD]2107
[/TD]
[/TR]
[TR]
[TD]Day's Cover
[/TD]
[TD]45
[/TD]
[TD]44
[/TD]
[TD]43
[/TD]
[TD]42
[/TD]
[TD]41
[/TD]
[TD]40
[/TD]
[TD]39
[/TD]
[TD]38
[/TD]
[TD]37
[/TD]
[TD]82
[/TD]
[TD]81
[/TD]
[TD]80
[/TD]
[/TR]
</tbody>[/TABLE]
Any help would be appreciated with this
[TABLE="width: 1243"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]34
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels
[/TD]
[TD]14/08/2018
[/TD]
[TD]15/08/2018
[/TD]
[TD]16/08/2018
[/TD]
[TD]17/08/2018
[/TD]
[TD]18/08/2018
[/TD]
[TD]19/08/2018
[/TD]
[TD]20/08/2018
[/TD]
[TD]21/08/2018
[/TD]
[TD]22/08/2018
[/TD]
[TD]23/08/2018
[/TD]
[TD]24/08/2018
[/TD]
[TD]25/08/2018
[/TD]
[/TR]
[TR]
[TD]Demand
[/TD]
[TD]38
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[TD]29
[/TD]
[/TR]
[TR]
[TD]Supply
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1245
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Min of Closing Stock
[/TD]
[TD]1177
[/TD]
[TD]1148
[/TD]
[TD]1120
[/TD]
[TD]1091
[/TD]
[TD]1062
[/TD]
[TD]1034
[/TD]
[TD]1005
[/TD]
[TD]977
[/TD]
[TD]948
[/TD]
[TD]2165
[/TD]
[TD]2136
[/TD]
[TD]2107
[/TD]
[/TR]
[TR]
[TD]Day's Cover
[/TD]
[TD]45
[/TD]
[TD]44
[/TD]
[TD]43
[/TD]
[TD]42
[/TD]
[TD]41
[/TD]
[TD]40
[/TD]
[TD]39
[/TD]
[TD]38
[/TD]
[TD]37
[/TD]
[TD]82
[/TD]
[TD]81
[/TD]
[TD]80
[/TD]
[/TR]
</tbody>[/TABLE]
Any help would be appreciated with this