

June 19, 2018

Hi i have seen your post for pivot for the rolling slicers for the month but how can we do it for the week if we have custom week start for the year. i.e Like my business year start for 2 July 17 and i want the rolling chart for the last 12 weeks. how can i do that please help. Thanks file is attached.


July 16, 2010

Hi Ahemed,
In the attached file your formula references cell S2, but this cell is empty so it's interpreted as 0 by the formula. Cell S2 should contain the date that you want to test against. e.g. today, yesterday, end of last week, whatever you want your last 12 weeks calculated from.
Also, the cell reference to S2 is not an absolute reference, so when you copy the formula down it doesn't stay fixed on S2.
Mynda
