last 12 months

[#1]

Hai   Friends,

Please see The Attach File

Please Select Year and month Then Ii will show only one month



but i want if i select 2010 and month feb then chart will show last 12 months along with feb month

it means jan-2009 to feb 2010

so please Give Me Better Solution

[SunilChauhan]

see the attached file

hope this helps you

[#3]

i did same as you sent

but they are asking like

if manuvally select year and month then chart will show last 12 month

any idea

[#4]

Try this expression

sum({1<FinalDate={">=$([12 rolling])<=$(MonthEnd)"}>} AmountTotal)

[#5]

hai Thanks,

but we have 8.2 set analysis not working pls send me solution with if analysis

[#6]

This would give the expression:

SUM( ALL IF( FinalDate >= [12 rolling] AND FinalDate <= MonthEnd, AmountTotal, 0 ) )

OR

SUM( TOTAL IF( FinalDate >= [12 rolling] AND FinalDate <= MonthEnd, AmountTotal, 0 ) )

[#7]

Hi Ram,

try using the way luminary gave you.

Build a field:

Date(Date(Date#(MONTH&'-'&YEAR,'MMM-YY'),'DD-MM-YYYY'),'MMM-YY') as MonthYear

Then

use this expression:

Sum( if( MonthYear >= Date(addmonths(Max(MonthYear), -12), 'MMM-YY') and MonthYear<= Date(addmonths(Max(MonthYear), -1),  'MMM-YY')

     ,

         AmountTotal

     )

)

translated from luminary expr with set analysis.

And put as dimension of your chart MonthYear.

It should work ... I hope

Regards

Giampiero