Structure of table is 4cols. 1st column name 2 column Curr week sales 3col previous week sales and 4th col %diff from prev week sales. how do i achieve as date column that i have we get 13 weeks data and on filtering for this week it will give me currr week sales but what for prev week col then?
2 respuestas
i reread your post and recommend that you use the 2nd method of https://jimdehner.com/2021/08/22/5-ways-to-do-yoy-and-ytd/ and you can filter for your 13 names - (if yo prefer video see https://youtu.be/F6DUYxLHAyU)
