This content has been marked as final. Show 7 replies
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.