Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
thanks, it very expensive to change script, cause we'll need to add set analysis with Period=Current at all objects in many reports.
It's cool!!
It is exactly what we need.
Thank you, Sunny!
Only in the reports where you replace the Year dimension with the ReportYear dimension.