YTD until selected day

[#1]

Hi guys,

I'am trying to display the information until a user selected date, the problem is

Example:

The user wants the YTD until 5 June, so he selects in months the JAN, FEB, MAR , ... JUN, in the weeks 1,2,3,4..,23 but now the problem how i select all the day's until 5 June?

[alexandros17]

If you need a sum of sales for example, then write

Sum({$ <myDate={'<=$(=GetFieldSelections(myDate))'}>} sales)

let me know

[#3]

no is not a particular function but all the data displayed, like the drill does

[ashfaq_haseeb]

Hi,

Below post might help you.

YTQ, QTD, MTD and WTD

Regards

ASHFAQ

[#5 · Accepted solution]

The solution was creating a button and set action "select in field": "my DateField" and the search string: = '>=' & vStartDate & '<=' & vEndDate, where my vStartDate it's the current year and vEndDate it's the selected date