9 Replies Latest reply on Dec 22, 2016 1:21 PM by Tableaunew learning

    Can't mix aggregate and non aggregate

    Tableaunew learning

      I am using two calculated fields to achieve desired results..

      1) Find maximum year from current data set


      2) when year equals to maxyear then returns discounts


      If Attr(Year)=maxyear then sum(discounts) else 0 end


      if doesn't give me any result.


      ANy help will be helpful