Is it possible to create a column layout whereby a Last Year column will be variable based upon the date filter.
ie, If the date filter is 01/01/10…30/04/10 then the Last year column will be 01/01/09…30/04/09
I can only get this year to be subject to this filter.
Any help would be most appreciated.
Andrew
Did you try to enter “-1Y” into the “Comparison Date Formula” column?
Hi Thomas! I do have the same problem of showing values for the same date filter /period last year… i have already used that -1Y on the Comparison date formula and tried all combinations of column type (i.e. Net Change, Balance at Date, and Year to date. Unfortunately, the account schedule overview returns the value as either unchanged or blank…
i really need a help on this… gosh! 
Hi Tomas!
I tried -1Y to get information from las year, but please tell me how can I get the amounts per each month from last year also?
Thank you !!
can u explain column wise
it gets resolved by me only thnk uuuu…