This content has been marked as final.
Show 2 replies
-
1. Re: Comparing similar tables
Glenn Kuly Feb 27, 2018 5:59 AM (in response to Céline Roman)Hi Celine, check out this video https://www.youtube.com/watch?v=CAZ3IAJEuCI and forward to the part dealing with the second workbook tab (Time Shift), which may help you out. It involves duplicating and blending, and how to time shift a data source.
-- Glenn
-
2. Re: Comparing similar tables
Céline Roman Feb 27, 2018 8:30 AM (in response to Glenn Kuly)Thanks Glenn, I'll have a look now.
In the meantime, I have been working with the table calculations, I think there might be a piece of solution as well.
I managed to get a full matrix with the information that i want.
From this matrix, I would just like to be able to use a filter to extract the information for a specific month.
I used a simple filter on the matrix but of course, it's just giving me blank values as my calculations are "based on the previous value in the table".