cumulative date

[souadouert]

Good morning

I have a cross table, I want when I select a date, a column displays the realization --> the date of selection and a column displays the cumulative from the beginning 2017 until the selected date

thank you

[Anil_Babu_Samineni]

May be this?

Sum({<date = {">=Yearstart(date) <=Max(date)"}>} Sales)

[souadouert]

anil  i want compare the year of date selection >2017   until the selected date

[Anil_Babu_Samineni]

May be i am not follow you, Would you provide more input on this. Better with few rows and expected result to see while selection happen

[sunny_talwar]

Are you looking to get YTD current year? What is your chart dimension?

[souadouert]

for exemple sunny i selected fev 2017 , so a column displays the realisation (fevr 2017) and other column (janv+fevrier 2017)

[sunny_talwar]

So, MonthYear is not a dimension? You want two expressions, 1 which gives the current monthyear and the other which is YTD (Year-to-date)?

[souadouert]

I will try with your method

[souadouert]

hello sunny

How to extract the month of a date as yyyy-mm??

[sunny_talwar]

Like this

Date(MonthStart(DateField), 'YYYY-MM')