set analysis compraison

[souadouert]

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

[Anil_Babu_Samineni]

date and year are which format? Perhaps this? If both are same format

  sum({<MV={'L'},year ={"=date<=year"}>}TOTAL_N)

[isingh30]

Please share your data.

Thanks.

[YoussefBelloum]

Hi,

you Mean Year of "selected" date <= Date of line ??

[sunny_talwar]

Souad - What is year of ligne?

[YoussefBelloum]

ligne (french) = line, so I think she talks about the year of the line

[sunny_talwar]

Make sense , year of which line?

[YoussefBelloum]

haha, she use date dimension on the table, so I think it is:

the Year of the Date of the lines of the table.

[sunny_talwar]

I still don't completely understand. May be provide some sample data Souad?

[PrashantSangle]

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,