7 Replies Latest reply: Jul 27, 2015 1:01 PM by Sunny Talwar RSS

    How do I write the correct formula to find the quantity sold in the last six weeks?



      I am trying to find the quantity of items sold in the last six weeks. Here is what my formula looks like:


      =Count({<Max(Week([Year Month]))={>=Max(Week([Year Month])-6)}>}[Unit Sold])


      When I enter that formula in, it doesn't show the correct value. Can anyone help me fix my formula?


      Thank you