5 Replies Latest reply: Oct 1, 2013 12:10 PM by vikas mahajan RSS

    How to find out stock for Day for max of date of month

      Hi Folks,



      Many Thanks in advance to see look over it this post.


      I stuck in a sitution. i ll explain it below


      I have dimension as Month [ jan , feb , March , Apr , May , June , July , Aug ,..., Dec ]


      I have on Field Stock_Date in which i have dates for all year and have another field as Stock having  Stock value according dates.


      All i want is to calculate : Sum of Stock for max Date of that month


      Ex:  Stock_Date  Stock

               01-01-2013  12

               03-01-2013  15

              26-01-2013  18

              26-01-2013  20



      So I want to show Sum of Stock on Max of Stock_Date ie: 26-01-2013  means 38 i want as result on selecting Jan.


      I want to show this info in Bar Chart so Month is My dimesion and Want expression which show result as i told above.


      If have any doubt please let me know i ll explain.








      Many Thanks In advance  !!!!!!!!!!!!!!!!!!!!!!