3 Replies Latest reply: Mar 9, 2018 2:26 AM by praveen A RSS

    show only current month record

    amber rebma

      in table i have a data like this

       

          

      HeadPrice MonthSub heads
      Marketing20012-Jan-17Mark1
      Marketing20013-Feb-17Mark2
      Marketing20014-Feb-17Mark3
      Misc12003-Jan-18Mark4
      Misc13001-Jan-18Mark5
      Misc130013-Jan-18Mark6
      Misc11005-Mar-18Mark7
      Ins12005-Mar-18Mark8
      Ins13005-Mar-18Mark9
      Ins15005-Mar-18Mark10

       

      now here i want to display only current month records and hide all previous old data.. like want to show + button and disable that and want to show current month record

        • Re: show only current month record
          Pritam Basak

          load the data to get the month number

           

          LOAD

                Head,

               Price,

               Month,

              Num(Month(Date#(Month,'DD-MMM-YY'))) as MonthNum,

               [Sub heads]

          FROM

          [D:\DataSample\Data2.xls]

          (biff, embedded labels, table is Sheet1$);

          --------------------------------------------------------------------------------------------

          Now in a straight table add

          dimension: Head,[Sub Heads], Month

          Expression : sum({<MonthNum={$(=Max(MonthNum))}>}Price)

           

          Capture1.PNG

            • Re: show only current month record
              amber rebma

              hi ...

               

              i tried this but not working ..

               

              i have records like this

               

               

              head  price month

              abc    234  3/9/2018 

              def    112   3/9/2018

              dfdf   244  3/9/2018

              239   124  2//1/2018

               

              and so on

               

              now i want like this data

               

              head  price month

              abc    234  3/9/2018 

              def    112   3/9/2018

              dfdf   244  3/9/2018

               

               

              what expression should i use for display all current month records .. i used this

                • Re: show only current month record
                  praveen A

                  abc:

                  load * Inline [


                  head,  price, month


                  abc,    234,  3/9/2018


                  def,    112,  3/9/2018


                  dfdf,   244,  3/9/2018


                  239,   124,  2/1/2018

                   

                  ];


                  xyz:

                  load head,price, month,

                   

                  num(month( Date#(month,'D/M/YYYY')))as Month1 Resident abc ;

                   

                  DROP Table abc ;




                  and in Straight table DImensions are: head and Month

                                                  Expression is : sum({<Month1 = {$(=max(Month1))}>}price)

                   

                   

                  You will get below o/p :

                   

                  293565.PNG