13 Replies Latest reply: Sep 14, 2017 10:25 AM by Shraddha Gajare RSS

    how to write the expression

    naveen kumar

      Hello All,

      can any one help me in achieving this requirement.....the thing is i need to show sum of volume against recommended R_Calmonth column  what i mean is

       

      Capture.PNG

       

      what i need to show for   R_Calmonth      201707 =201704+201705+201706 which is  1600+1600+1768  =4968

                                       for                            201708=201704+201705+201706 +201707 which is   1600+1600+1768+400=5368

                                                                        201709=201704+201705+201706 +201707+201708 which is   1600+1600+1768+400=5368(beacuse i dont have any volume for 201708)

       

       

      Expression i tried is

                                   Actual:  Sum({<CALMONTH = {">=$(=YearStart(Max(CALMONTH))) <$(=max(CALMONTH))"}>} VOLUME)

                                   

      but i am not getting expected output

      Capture1.PNG

       

      Any suggestion plz

       

      thanks

      Naveen