9 Replies Latest reply: Feb 13, 2018 10:34 AM by Prashant Sangle

# set analysis compraison

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

• ###### Re: set analysis compraison

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

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

• ###### Re: set analysis compraison

Thanks.

• ###### Re: set analysis compraison

Hi,

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

• ###### Re: set analysis compraison

Souad - What is year of ligne?

• ###### Re: set analysis compraison

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

• ###### Re: set analysis compraison

Make sense , year of which line?

• ###### Re: set analysis compraison

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

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

• ###### Re: set analysis compraison

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

• ###### Re: set analysis compraison

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,