3 Replies Latest reply: Aug 26, 2011 1:41 AM by Shanthi D RSS

    Sort order

      Hi,

       

      Need to show the latest Six months in ascending order in the chart...

       

      Say for example,

       

      For the Year 2010, chart should display the values from 201007 to 201012 in ascending order...

       

      If particular month has no sales then we need to consider the previous months also like month 201008 has no sales then we need to show the months - 201006 ,201007,201009,201010,201011,201012.

        • Re: Sort order
          Sunil Chauhan

          please see the attached

            • Re: Sort order

              But I guess Shans_Bola wants it for latest 6 months.

              So Sunil could you suggest how we can do it.

              Because if I change the inline load in your example to something like this,

               

              Tab1:

              Load * inline [

              colm,sales

              201104,20

              201105,50

              201106,100

              201107,200

              201108,0

              201109,400

              201110,500

              201111,600

              201112,600

              ];

               

              then in ths front end I get this

              Colm
              Sales
              20110420
              20110550
              201106100
              201107200
              201109400
              201110500
              201111600
              201112600

               

              Thanks beforehand,

              Regards,

              Bikash

                • Sort order

                  Hi,

                   

                  This can be achieved by using the below setups

                   

                  1. Set the Sort order to 'Ascending order'

                  2. Set the Maximum visible Number to 6 (available in presentation tab)

                  2. check the option "Reversed" in the presentaion tab