last year and current year

[#1]

Hi ,

I have a report which compares current year sales with previous year sales.I have attached the doc which shows my report.

As in the example when I select the subcain-MITRI for fiscal year-2012 and month as oct I get sales in the current for 4 stores which is good but for last year the sales are shown for 2 stores because last year the subchain was MILEAS and now it changed to MITRI.Is there a easy way to show up the last year stores also under subchain MITRI.I cant harcode as there would be many occurances for this.

Pls help.Pls let m eknow if you need additional info.

Thanks,

Swetha

[#2]

Hi Swetha,

Can you sent a small test-app, because i can't open your document.

Halmar

[Miguel_Angel_Baeyens]

Hi Swetha,

I don't if you have already but check this application that does year to date analysis using set analysis and flag fields in the calendar table, plus some variables in calendar objects.

Hope that helps.

Miguel

[SunilChauhan]

use below code       Sum({$<Year={$(=only(Year)}Sale)_Sum({$<Year={$(=only(Year)-1}Sale)

[#5]

Thanks Miguel!

I have done all the comparison b/w previous year and current year sales and everything looks good .Now only problem is in my app as I have shown in the doc the the sales for previous year also need to come under the same filed value as current year.

As I have shown for current year the store-0925,1139,1159,3058 are shown under MITRI(subchain field value) but for last year store-1159 and 3058 are shown as 0 because they belong to MILEAS(subchain field value).I mean the subchain name changed from MILEAS to MITRI from last year to current year.Please let me know how do I proceed.

Thanks,

Swetha

[#6]

Thanks Miguel!

I have done all the comparison b/w previous year and current year sales and everything looks good .Now only problem is in my app as I have shown in the doc the the sales for previous year also need to come under the same filed value as current year.

As I have shown for current year the store-0925,1139,1159,3058 are shown under MITRI(subchain field value) but for last year store-1159 and 3058 are shown as 0 because they belong to MILEAS(subchain field value).I mean the subchain name changed from MILEAS to MITRI from last year to current year.Please let me know how do I proceed.

Thanks,

Swetha