we want torestrict straight table and want to show only 24 months from avaialbe 36 months fromtable

[singhcv123]

we have 1 requirement where data in straight table is look like this

id	sales	month
1	100	Jan-13
2	200	Feb-13
3	300	Mar-13
4	400	Apr-13
5	500	May-13
6	600	Jun-13
7	700	Jul-13
8	800	Aug-13
9	900	Sep-13
10	1000	Oct-13
11	1100	Nov-13
12	1200	Dec-13
13	1300	Jan-14
14	1400	Feb-14
15	1500	Mar-14

and 1st initial requirement is to show the data like data should display in a monthly columns@ and than restrict it for rolling 24months data from available 36 months..how this scenario is possible

id	sales	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13
1	100
2	200
3	300
4	400
5	500
6	600
7	700
8	800
9	900
10	1000
11	1100
12	1200
13	1300
14	1400

kindly suggest

[VishalWaghole]

Hi virendra,

Try this expression in your chart,

=sum({<MonthNameField={">=$(=AddMonths(MonthNameField,-24)"}>}sales)

Hope it work for you.

-- Regards,

Vishal Waghole

[SunilChauhan]

=sum({<MonthNameField={">=$(=AddMonths(Max(MonthNameField),-24)"}>}sales)

[VishalWaghole]

Hey extremely sorry i forget to add Max(MonthNameField)

[SunilChauhan]

sum({<MonthNameField={">=$(=Date(AddMonths(Max(MonthNameField),-24),'MMM-YY'"}>}sales)

[singhcv123]

sorry to say but this set analysis will help me find out the rolling sum of data .but i want individual presence of the 24 months and data should visible accordingly.

i dont want rolling some  data for last 24 months.

i want to show last 24 columns without any current selections.