Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sunny i
I used this expression, you think it is a solution does not generate problems later
=sum(if(Year(Date#(getfieldselections(SITUATION_PRODUIT), 'YYYY-MM')) ='2016'and MONTH(Date#(getfieldselections(SITUATION_PRODUIT),'YYYY-MM')) <=Month(Date#(SITUATION_PRODUIT, 'YYYY-MM')), REAL_PACKS.NOMBRE_PACK))
May be this?
Sum({<date = {">=Yearstart(date) <=Max(date)"}>} Sales)
anil i want compare the year of date selection >2017 until the selected date
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
Are you looking to get YTD current year? What is your chart dimension?
for exemple sunny i selected fev 2017 , so a column displays the realisation (fevr 2017) and other column (janv+fevrier 2017)
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)?
I will try with your method
hello sunny
How to extract the month of a date as yyyy-mm??
Like this
Date(MonthStart(DateField), 'YYYY-MM')