Hi Jacek! At 09:43 I tried to copy the data from the pivot table to the next month but it didn't work like yours did on excel? Did you do copy and paste? I also could not drag the cells across for the rest of the months and had to do it manually. Any idea what I did wrongly? Thank you!!
Hi Sarah, try typing in the formula (e.g. =B5) rather than clicking on the cell. Now try to copy and paste it to the right. Let me know if it worked!!:)
![[500Distro] Retention and Cohort Analysis with Bei Lu](http://i.ytimg.com/vi/VvYV0V-kxr0/mqdefault.jpg)
Thank you Jacek, this has been very helpful
thank you for explaining with dat set given, its really helpful
Hi Jacek! At 09:43 I tried to copy the data from the pivot table to the next month but it didn't work like yours did on excel? Did you do copy and paste? I also could not drag the cells across for the rest of the months and had to do it manually. Any idea what I did wrongly? Thank you!!
Hi Sarah, try typing in the formula (e.g. =B5) rather than clicking on the cell. Now try to copy and paste it to the right. Let me know if it worked!!:)