build budget by adding 10% of previous month

[Anonymous]

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

[Anil_Babu_Samineni]

Can you explain little more your request? Perhaps this

Sum({<Year={$(=Min(Year))}, Month={$(=Min(Month))}>} Sales) * 0.10

[arvind1494]

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