4 Replies Latest reply on Oct 10, 2018 10:50 AM by Ritesh Bisht

    get time for max orders

    scuby me

      Hi,

      I am stuck with a calculation. Please find the attached workbook below

      I have a dimension called item. I wanted to get for example For 'class C' the max value is 528 and at the time 11:00 so I want to get 11th hour the max sale is 528 and similarly for others class B -->34 at the hour 1 o clock . For hours which crosses 12, I want to give it as 1, 2 instead of 24 hours I want 12-hour format.

       

      Thanks