Organic Vs Inorganic Growth

[rido1421]

Hi All

I would like to create a Model displaying the Organic and Inorganic Sales value growth based on customers for previous year and current year

is there perhaps any sample qvws that I could use as a guide?

[rido1421]

Hi There

Please could someone advise what the below expression is doing and does it make sense...

=num(sum(aggr(if(sum({1<Fin_Year={$(vMaxFinancialYear)}>} $(vSales)) <> 0

and

sum({1<Fin_Year={$(vPrevFinYear)}, Fin_Period = {"<= $(vMaxFinancialPeriod)"}>} $(vSales)) > 0,sum({1<Fin_Year={$(vMaxFinancialYear)}>} $(vSales))),Customer)),'R # ##0;R-# ##0')