2 Replies Latest reply on Jun 18, 2013 8:11 AM by Tracy Rodgers

    Trailing 3 months and Current Month in Same View

    Joe Knight

      Hello,

       

      I need to create a view that shows sales by product (row shelf) for both the current month and trailing 3M total (column shelf) . i.e. the current month needs to be captured in both fields. Groups haven't worked and I don't think sets will either.  I know I can use the LAST() to pull the data and make current month discrete but I lose Grand Totals when I do that.  Any ideas would be helpful.

       

      Thanks,

      Joe