Cumulation ?

[#1]

HI All,

I am having Amount field on the Basis of Credit & Debit from 2012 on wards...

I am Selecting Any month :

Ex:  Jun-2013, then Debit - credit till Jun-2013

       Mar-2013, then Debit - credit till Mar-2013

       Apr-2013, then Debit - credit till Apr-2013

After this I want get Last 12 MOnths Avg AMount...

If I Select Jun-2013, Then Output should be :

(Jun-2013, then Debit - credit till Jun-2013  +

May-2013, then Debit - credit till May-2013 +

May-2013, then Debit - credit till May-2013 +

......

.....

.....

July-2012, then Debit - credit till June -2012 )

Like cumulation process, Can any one help me on this....

Regards,

Helen

[jagan]

Hi,

Try like this if you have a date field

1. For selected month

Dimension:

=Sum(Debit) - Sum(Credit)

2. For last 12 months

=Sum({<YearDimensionName=, MonthDimensionName=, DateDimensionName={'>=$(=MonthStart(Max(DimensionName), -11))<=$(=MonthEnd(Max(DimensionName)))'}>}) -

Sum({<YearDimensionName=, MonthDimensionName=, DateDimensionName={'>=$(=MonthStart(Max(DimensionName), -11))<=$(=MonthEnd(Max(DimensionName)))'}>}Credit)

Note: Replace YearDimensionName, MonthDimensionName and DateDimensionName with your actual field names.

Hope this helps you.

Regards,

Jagan.

[its_anandrjs]

For last 12 months you can try this way also

=Sum({<DateField={'>=$(=Addmonths(Max(DateField), -11)) <=$(=(Max(DateField)))'}>}) -

  Sum({<DateField={'>=$(=Addmonths(Max(DateField), -11)) <=$(=(Max(DateField)))'}>}Credit)

And rest of the filter to be used according to use.

Regards

Anand

[#4]

HI Anand Can you implement for this qvw...

cumulative issue?