Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How we can find out the increase in the sales amount for perticular Date range.
-Nilesh
Do you mean to say the user hast to select the date range "From and To date"
No i have two colums Start Date and End Date.
-Nilesh
Just select the value and see the expression change
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
Do you want to compare the start date sales with End date sales(Increased)? then follow the SALTO's comment....