3 Replies Latest reply on Jan 29, 2014 6:04 PM by Alex Riffle

    Rolling Date "Filter"

    Alex Riffle

      Hello.

       

      I'm working on a KPI's dashboard for our product developers. I need to build a simple text table that shows the revenue in each month attributable to new products.

       

      So I have a "Product Launch Date" field, and I basically need to make it so that in each month, revenue is shown for products launched within the previous six months. For example, August '13 would show total Revenue for products with a lunch date between Feb and Aug of '13. December '13 would show Revenue for products launched between June and Dec '13.

       

      Any ideas?

       

      Thanks!