> 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')

[sunny_talwar]

What is the issue you are running into?

[deepakqlikview_123]

I am not able to get aggregated value eual to value in that perticular selection.

below is discussion for this.

Pivot table condition

[sunny_talwar]

Would you be able to attach a sample here?

[deepakqlikview_123]

PFA

[deepakqlikview_123]

Hi all,

Can you please suggest on this how shall i go ahead to get result as shown in attachment.

PS-I am using pivot table

Thanks

[sunny_talwar]

Try this expression
SUM({<AR_CustomerLedger.MonthYear>}AR_CustomerLedger.OpenAmount)

[deepakqlikview_123]

hi sunny,

thanks for response it is  working fine for last 3 months data.moreover can you please suggest how to sort the column in descending order of month year.

thanks

[sunny_talwar]

it is  working fine for last 3 months data

Not working for other data?

[sunny_talwar]

Check attached