9 Replies Latest reply: Aug 21, 2015 10:36 AM by jagan mohan rao appala RSS

    Sales for ongoing year and compare with previous year

      Hi guys,


      There are 2 things I am trying to go but it looks I need a bit help:


      I'm trying to build a dashboard for my sales team, I'm connected to db where the timestamp of my orders is mentionned in OrderDate


      1. I want to get the sales of the ongoinf year but the formula below returns '0'


      Sum({$<OrderDate = {$(=year(Max(OrderDate)))}>} Sales) - What am I doing wrong here?


      I have to uses Max(OrderDate) instead of today() As I am working with sample data from 2008



      2. I also want to compare the data of sales of the ongoing year with the data of the year before at the same day


      For example: On 1/6/2008 I want the total of sales from 1/1/2008 until 1/6/2008 but I also want to know the sales of 1/1/2007 until 1/6/2007


      Thank you for your help