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 Any help would be appreciated with this

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

View the last value in grouped pivot table

Thread starter marbr796
Start date Aug 14, 2018
Tags

closing days groups pivot table rolled

marbr796

New Member

Aug 14, 2018

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