Added a packaged workbook with a made up data set, This would be the desired results of the calculation from this data set:
Site Date of Last Increase Atlanta 5/1/18 Boston 5/1/18 Chicago 5/1/18 Cleveland 6/1/18 Dallas 7/1/18
Please note that the original data source is an Access database.
Thanks for the workbook and expected results table.
I think it was mostly there, maybe just needs
one additional calculation and a filter.
The additional calculation is [Max Increase Date]
with Table Calculation settings of for both Nested Calcs
of Specific Dimensions of [Site],[Year],[Month] restarting every Site
In the summary table, all those fields get moved to the Detail shelf,
which will cause duplications of your end result. To filter down to just
one copy, you can put Index() on the Filter shelf, set its Table Calculation
settings to be the same as Max Increase Date, and then move the min
and max to just 1.
Please see workbook v2018.2 v10.2 attached in the Forum Thread.
277373max.twbx 74.1 KB
Awesome, thanks for the help!