3 Replies Latest reply: May 11, 2016 10:11 PM by PAUL YEO RSS

    How to plot average sales by year ?

    PAUL YEO

      Hi All

       

       

      I have chart 1 using below expression , working fine all the time :-

       

       

      money(

      sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

      May i know how to convert it so that it will display average sales by year.

       

       

      Note that 2016 only have 4 month and 2015 have 12 month. How to automatic adjust ?

       

       

      2015 should display 347/12= 28.9

      2016 should display 104/4 = 26

       

       

      Paul