Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have straight table with date and client , ans i have this expression
sum({<MV={'L'},year ={'<=$(=(year ))'}>}TOTAL_N)
i need to sum TOTAL_N when year of date <= year of ligne
date and year are which format? Perhaps this? If both are same format
sum({<MV={'L'},year ={"=date<=year"}>}TOTAL_N)
Please share your data.
Thanks.
Hi,
you Mean Year of "selected" date <= Date of line ??
Souad - What is year of ligne?
ligne (french) = line, so I think she talks about the year of the line
Make sense , year of which line?
haha, she use date dimension on the table, so I think it is:
the Year of the Date of the lines of the table.
I still don't completely understand. May be provide some sample data Souad?
Year & Date are coming from same table or different??
is there any relation between both field
Please provide sample data and little bit more explanation which help us to provide more accurate solution.
Regards,