7 Replies Latest reply: Feb 8, 2016 5:23 AM by Sunny Talwar RSS

    Set analysis

    Prasanta Kumar



      I have three columns as below


      Month (201502, 201503, 201504)


      sales total (143432,41234,234123,23412,.....)


      I want to get the sum of sales for max(month) for category 3


      but i am not able to write the exact syntax to select the max of month and filter category 3 to get the total sum.


      please help me with the syntax for set analysis.