6 Replies Latest reply: Jul 12, 2018 2:16 AM by Igor Banjac RSS

    KPI comparison current year vs previous year

    Igor Banjac

      I have a small problem and I was wandering if anyone could help me. I've looked other threads, but couldn't solve it.

       

      For selected year total sales KPI I created this expression:

       

      Sum({$<OrderDate.autoCalendar={Year}>}Sales)

       

      Now I'm having trouble doing it for the previous year total sales KPI that I want to put next to the first one.

      How do I do it?

       

      Thanks in advance.