Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I wanna show the Sales value or calculate the sum of sales based on user date inputs
This is the table for your ref.....
Use a n Input Box. this will let the user to enter the values he want.
Now you use calculated dimension with if condition as where Sales >= the Value entered by user in input box.
Assuming you load the dates as valid QV dates, then in a text box:
=Sum({<Date = {">=$(=vMinDate) <=$(=vMaxDate)"}>} Sales)
The exact expression will depend on how the Date field and the two variables are defined and formatted.