3 Replies Latest reply on Jun 21, 2017 2:30 PM by Ragav P

    Show only the Max Month for a category

    Ragav P

      Hello Guys,


      I am trying to find a solution for the below question. It would be really great if someone can shed some light.


      I want to show only the Max number of orders for each category for whole year & Max profit for each category for the whole year. Only the respective month value to be shown others should be null


      Max month each year.PNG


      Max Profit each year.PNG


      Any help here? Also I want them to be shown under the same view, possible? I tried using WINDOW_MAX function but seems like I am not using it in proper way definitely there needs to be something else with that. Let me know.