2 Replies Latest reply on Dec 11, 2017 7:46 PM by Kazybek Beken

    How to calculate sales of previous month?

    Kazybek Beken

      Dear friends,

       

      I'm using filters YEAR(Order Date) and MONTH(Order Date). And based on that filters I'm calculating sales of our stores for that particular month. But I also need to add another column to compare - sales of the previous month.

       

      What kind of a calculation can I use?

       

      P.S. I know that I can create a parameter and calculate everything based on a parameter, say, [Report Month]. But, for some reasons, I need only date filters.