Increase in Sales

[nilesh_gangurde]

Hi,

How we can find out the increase in the sales amount for perticular Date range.

-Nilesh

[#2]

Do you mean to say the user hast to select the date range "From and To date"

[nilesh_gangurde]

No i have two colums Start Date and End Date.

-Nilesh

[sujeetsingh]

Just select the value and see the expression change

[salto]

Do you mean the sales percentage varitaion between two different time periods?

In that case divide the sales amount in the second period and the sales amount in the first period.

For a particular Year the set analysis expression could be something similar to:

=sum({<Year={$(=max(Year))}>} SalesAmount) / sum({<Year={$(=max(Year)-1)}>} SalesAmount)-1

[#6]

Do you want to compare the start date sales with End date sales(Increased)? then follow the SALTO's comment....