6 Replies Latest reply on Dec 7, 2017 3:26 PM by Dimitriy Shcherbenko

    Groupping values by quarter, half year and year

    Dimitriy Shcherbenko

      Hi guys!!!

       

      Would you be so kind to help me with solving the following issue:

       

      I need to create parameter that will groupe my values by months, quaters, half years and years.

       

      I managed with month case in the following may: I create two parameters (Start_Date & End_Date). Then I create a calculated field that output my results in the limits of sated parameters. Everytrhing works well.

       

      However such trick is not working with quaters, half years and years and I am quite confused how to solve it.

       

      Thank you in advance for your attention and help!!!

       

      Please find attached my workbook.

       

      Case is urgent! Count on your help!