2 Replies Latest reply on Dec 20, 2016 6:31 AM by Nicholas Hara

    how to calculate week rolling average and 6 week rolling average in the same table

    mridula.sori

      Hi, Can someone please help on how to calculate week rolling and 6 week rolling in one table. Measure names 07/12/2016 06/12/2016 05/12/2016 04/12/2016 03/12/2016 02/12/2016 01/12/2016 Week Average Last 6 weeks average A 88.96 100.00 100.00 100.00 100.00 100.00 100.00 98.50 93.68 B 163 186 188 215 158 158 134 172 171 this is rolling average based on daily data. Thanks M