4 Replies Latest reply: Jan 21, 2015 6:43 AM by Андрей Шепель RSS

    The same period in prior year

    Андрей Шепель

      Good day!

      In my model i have fields Year, YearWeek.

      Also in pivot table there is expression , which calculate sum of volume for current selection

      In second expression i need to calculate sum of volume for same period, but with prior year.

       

      For example:

       

      1. if i select Year 2014, second expression ,must calculate for Year 2013

      2. if i select YearWeek 201301,201302,201303, second expression ,must calculate for 201201,201202,201203

       

      Thank you!