I currently compare the last 13 periods against a table - now I use pivot tables I see I can get them to sort in the same sequence. However I want this sequence to be dependant upon a starting date.
Obvioulsy P4 today will be P5 in 4 weeks- I would like the pivot table result to count back from today period ( easy to set this by using a table ).
I take todays week no. convert to a Period and then count back 13 periods from here including the year eg P1 2015 was proceeded by P13 2014
Is this possible- i currently use index match but this is extrememly slow way of doing it will data tables and pivot results are far quicker
Bookmarks