> 12 month value aggregation in one column

[deepakqlikview_123]

I have month year column.

I need to aggregate value for all month year having value > 12 month, I am using dimension as per below please suggest.

=If(Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY') >= Date(AddMonths(Today(),-11), 'MMM-YYYY'), Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY'), '> 1 Year')

[deepakqlikview_123]

Hi Sunny,

The total results in >1 year column in 1 year drop down selection and > 1 drop down selection total in chart is not matching.

and in latest app 3 month , 6 month, 9 month,12 month not showing  as per need

Thanks

[sunny_talwar]

I am not sure what you want Deepak... Unless you can clearly provide me the expected output... I might not be able to help you brother....

All the best

[deepakqlikview_123]

Hi Sunny,

As shown in above image attachment the view for 1 year drop down selection in list box.(having >1 year column)

Fot 3 month, 6 month , 9 month , 12 month drop down selection in list box need to show previous 3,6,9,12 month resply.

For > 1 year view need to show those month like

Sum({<AR_CustomerLedger.MonthYear ={"*"}-{">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver) this

Total in >1 year view and > 1 tear column in 1 year view should match.

Thanks