Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello qlikers ,
i have a task on build budget by adding 10% of previous month total sales amount
note that data min orderdate is 2010 and max is 2015.
please help
Can you explain little more your request? Perhaps this
Sum({<Year={$(=Min(Year))}, Month={$(=Min(Month))}>} Sales) * 0.10
Sum({<Year={$(=Max(Year,-1))}, Month={$(=Max(Month,-1))}>} Sales) * 1.10
This will give you Budget :
pevious year month sales + 10% pevious year month sales