1 Reply Latest reply on Mar 1, 2012 11:53 AM by Tracy Rodgers

    Last 90 Days

      I am attempting to create a calculated field that will return to me the last 90 days worth of a measure.

       

      I know that you can do this using the relative date dimension, however, if I rely on the relative date field, it limits me from putting different measures on the shelf that do not need the last 90 days field. 

       

      To clarify, I provide a weekly executive report that has several different measures with different time dimensions.

       

      For example:

       

      Last week installs

      Last week deinstalls

      Customers Not Serviced in more than 30 Days

      Stores with multiple stockouts in 90 days

       

      As you can see, there are 4 different measures here with 3 different time dimensions.

       

      I have figured out the rest of them by creating a calulated field, but am having trouble and need help with the 90 days calculation.

       

       

      Can anyone help????