Based on the error message, you need to wrap each of your non-aggregate fields in the calculated field in ATTR(), MAX(), or MIN(). If you shared the calculated field that gives the error message, there are any number of people on here that can help.
Thank you for your reply. i have numbers of transactions with relationship and this calculation :
IF ATTR([Transactions2].[Authorisation Date])>=ATTR([Second Max Date per AFM]) and ATTR([Transactions2].[Authorisation Date])<=ATTR([Max Order Date per AFM]) THEN SUM([Transactions2].[Transactions]) END
*14 September Second Max Date per AFM
20 Max Order Date per AFM
but if removed authorisation DAY from rows sum of transactions for each MerchantAFM is null.
Calculating Sum of Transactions between last two dates per Merchant AFM i receive this error