rolling last year total

[selcukcadir]

Hi,

gwassenaar published  (thanks you gwassenaar)

I want to add

last year total sales

add as a new column

This can be done added ?

[selcukcadir]

Hi all,

Could you give support to this issue?

thanks.

[selcukcadir]

Hi all ,

set analysis ,How to solve this problem?

[selcukcadir]

hi all,

correct  ;

if(Year(AsOfPeriod)-1 = '2009',sum(total {$<Year={$(=2009)},PeriodType={'Current'}>} Sales))     

But not correct ; dynamic solution

1 trial ;    sum(total {$<Year={"=$(#=Year(=Only(AsOfPeriod)-1))"},PeriodType={'Current'}>} Sales)

2 trial ;    sum(total {$<Year = {"$(Year(AsOfPeriod)-1)"},PeriodType={'Current'}>} Sales)

vLast  = Year(AsOfPeriod)-1

3 Trial ; sum(total {$<Year={$(vLast)},PeriodType={'Current'}>} Sales)

Why not correct  ? Help....

[Gysbert_Wassenaar · Accepted solution]

Add records to the AsOf table to link each period with every month of the previous year:

CONCATENATE (AsOfPeriodTable)

load Period as AsOfPeriod

,'LastYearTotal' as PeriodType

,date(addmonths(yearstart(Period),-iterno()),'YYYYMM') as Period1

,Year(Period) as Year

Resident PeriodTbl

while IterNo()<=12;

Then use this expression: sum({<PeriodType={'LastYearTotal'}>}Sales)

[selcukcadir]

Thank you Gysbert,

I have another question. Can you help me.

Period Year Ago  and  YTD Year Ago    how to add ?

thank you for great post