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

    Set analysis

    Prasanta Kumar

      Hi,

       

      I have three columns as below

       

      Month (201502, 201503, 201504)

      category(2,3,4,5....)

      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.