Year to Year Analysis

[Anonymous]

Hi, all

Could you please help me with calculation of gross rate for selected period to the same period of prior year (year to year analysis). Would you be so kind to show this using the attached example.

Thank you in advance.

[sathishkumar_go]

Hi,

use setanalysis.

sum({<YEAR = {'$(vCurYear)'} >} SALES_AMOUNT)

sum({<YEAR = {'$(vPreYear)'} >} SALES_AMOUNT)

VCurYear and vPreYear is a variable to get the value of current year and previous year

-Sathish

[HirisH_V7 · Accepted solution]

Hi,

Check this,

Dimension:

Product

Expression :

Previous Year-      Sum ({<YEAR={"$(=Max(YEAR)-1)"}>}SALES_AMOUNT)

Current Year-        Sum ({<YEAR={"$(=Max(YEAR))"}>}SALES_AMOUNT)

HTH,

PFA

Hirish

[maxgro]

max, as already suggested, or only (there is a small difference)

Sum ({<YEAR={"$(=only(YEAR)-1)"}>}SALES_AMOUNT)

[everest226]

Sum ({<YEAR={"$(=only(YEAR)-1)"}>}SALES_AMOUNT)

[Anonymous]

Sathish, thank you for this idea, however i do not have any result using this construction

sum({<YEAR = {'$(vCurYear)'} >} SALES_AMOUNT)/sum({<YEAR = {'$(vPreYear)'} >} SALES_AMOUNT)

[Anonymous]

Hirish, many thanks for your example - it works