4 Replies Latest reply on Feb 20, 2016 1:04 PM by Mahadev Somashekhar

    Incorrect Filter Behavior when adding total

    Mahadev Somashekhar

      Dear Sir/ma'am,

      I have a dataset with Year 2011 to 2014, my aim is to display Sales of the Latest Month.

      I achieved this by writing the below formula

       

      MAX([Order Date (Years)]) == TOTAL(max( [Order Date (Years)])) and then filtering Value = 'TRUE' as below

       

       

       

       

      However when I add the Total to it, I am getting sum of sales of the previous years, kindly advise