Comparison sum sales in Year with Previous Year

[t_chetirbok]

Hi!

I need to create straight table where Dimensions are Customer, Product, Storage, Year

and Expressions are sum(Sales) in Year and sum(Sales) in Previous Year.

Something like this:

where number in column F is Sales in 2015 and number in column G is Sales in 2015 -1

Any idea how can I do it?

Many thanks!

[sunny_talwar · Accepted solution]

If you are ever going to select one year, then may be this:

=Before(Sum({<Year = {$(=If(GetSelectedCount(Year) = 1, GetFieldSelections(Year)-1, Chr(39) & '*' & Chr(39)))}>}Sales))

[t_chetirbok]

thanks, it very expensive to change script, cause we'll need to add set analysis with Period=Current at all objects in many reports.

[t_chetirbok]

It's cool!!

It is exactly what we need.

Thank you, Sunny!

[Gysbert_Wassenaar]

Only in the reports where you replace the Year dimension with the ReportYear dimension.