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

      maxyear=max(year)

      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

       

      Thanks.