0 Replies Latest reply: Jul 17, 2016 8:33 AM by Evgeny Stuchalkin RSS

    Show past year sales on current year line

    Evgeny Stuchalkin

      Hello!

       

      I have app with caledar with fact data on several years.

       

      I want to build table mith measure Past Year Sales, that will be shown in one line with current year. It's critically important, to see past year sales in line of current year.

       

      1295ff7f80.jpg

      My current psta year sales formula is.

       

      Sum({$<[Тип даты]={'Закрытие сделки'}, [Win]=-{0},[YEAR]={$(=max(YEAR)-1)}>}[Бюджет])