Sort order

[#1]

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.

[SunilChauhan]

please see the attached

[#3]

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
201104	20
201105	50
201106	100
201107	200
201109	400
201110	500
201111	600
201112	600

Thanks beforehand,

Regards,

Bikash

[#4 · Accepted solution]

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