Hi,

I am trying to come up with a formula to net down aged data but I am struggling! 

This is a sample from my pivot, I want to run the formula alongside it and what I am trying to do is:

For customer 1 to net off the -735 from 4 Years+ with the 735 in 90-180 so it only shows 735 left in 60-90 days. Then when I refresh the pivot each month these will adjust and then the ageing formula will adjust alongside it.

Thanks,

James

​Hi, I am trying to come up with a formula to net down aged data but I am struggling!  This is a sample from my pivot, I want to run the formula alongside it and what I am trying to do is:For customer 1 to net off the -735 from 4 Years+ with the 735 in 90-180 so it only shows 735 left in 60-90 days. Then when I refresh the pivot each month these will adjust and then the ageing formula will adjust alongside it.  Thanks,James   Read More

​