7 Replies Latest reply: Nov 15, 2017 7:11 AM by firat ada RSS

    textbox rank sum set analysis

    firat ada

      hi there,

       

      ı have a table like that ;

       

        

      termsales
      20171190
      20171090
      20170999
      20170890
      20170789
      20170688
      20170586
      20170485
      20170384
      20170296
      20170181
      20161280
      20161179
      20161079
      20160977
      20160877
      20160775
      20160676
      20160573
      20160474
      20160372
      20160271
      20160170
      20151270
      20151169
      20151068
      20150966
      20150866

       

      I want to write in the textbox  that ;

       

      'in the last (12) months of term, rank=1 and rank=2 sum(sales) are .99., 96...  and in these months are .201709 and 201702. '

       

      again I am having difficulty with the syntaxes of set analysis......