till date

[#1]

i hav a date column, i want user to select a date and the records to be shown till tht date,

object can be a chart

and

also a table box.

[sujeetsingh]

In chart you can implement it with if() case statement or set analysis but can not in Table Box.

See this example

[#3]

example is misssing

[sujeetsingh]

Sorry for that ,

now it is there.

[#5]

Hi

Please try below this expression.

{<Year={$(vMaxYear)},MonthOrder={"<=$(=Max({<Year={$(vMaxYear)}>}MonthOrder))"}>}

vMaxYear = Max Date Year(Variable)

Create a field in time dimension 'MonthOrder'

MonthOrder like 1,2,3...12

MonthOrder field u will get from Month(If Month=Jan,1,If Month=Feb,2 Like.....)

Regards-Bika

[#6]

hey date selection is giving me sum of tht date,

i need till tht date,

if i select 12/11/2010, sum shld come 18

[#7 · Accepted solution]

You need to keep master calender with all date for selction

Find the attachment.. it may help you

Karthik

[#8]

bika,

Ur exp is not working

[#9]

Thanks Karthik,

bt its nt working, whn i select other dates frm calender mismatch occurs...

[#10]

Could you explain little more..

It look like ok for me.

Please give feedback with example value..