Use Field Value in another field in Set analysis

[RichardRozgonyi]

Hello everyone,

Could someone please help me.
I need help with the following calculation.
I would like to calculate the amounts per mandate no. before the last login.

I have already tried with many formulas without success.
All data is in a table in the script.

Thanks in advance.

 

[PrashantSangle]

Can you share sample data?

[PrashantSangle · Accepted solution]

Try below 

chart Type - Table

dimension - mandate_nr, last_login

Expression1 - Sum(value)

Expression2- Sum(if(invoice_date<last_login,value,0))

Regards,

Prashant Sangle

[RichardRozgonyi]

The answer is very good thank you, works perfectly.
I didn't see the forest because of the tree in front of it (I was thinking too complicated).

Thank you very much Prashant Sangle

[RichardRozgonyi]

Hello,

I would like to know the following.
I also have a calendar bound to the data model.
In Expression1 - Sum(value) (calendar is taken into account)
IExpression2- Sum(if(invoice_date<last_login,value,0)) (calendar should not be taken into account)
How do I do this?

BR Richard

[PrashantSangle]

Can you explain little bit more with example 

[RichardRozgonyi]

I have found the solution. Thank you very much for your help.

Sum({<Year=, Month=>}if(invoice_date<last_login,value,0))