Hi,
i'm trying to create 2 set analysis for my project.
1* Must give the cost for an date (year -1) of the actual selection(year)
2* Must give the cost for an date (month+1) of the actual selection(month)
Actually, the user can choose in 2 dimensions ([Année de Quittancement],& [Moisde Quittancement]), the cost of the contract. Imagine that the user choose : july(7)- 2013, he as the cost for this date. My set analysis must give him (on the same line) the information for August(8)-2013 & december 2012.
To understand it :
TABLE1:
..
QTTERM as [Date de Quittancement],
Year(QTTERM) as [Année de Quittancement],
Month(QTTERM) as [Mois de Quittancement],
Num#(Year(QTTERM)-1)as [Année Date Solde-1],
Num#(Month(QTTERM)+1)as [Mois Date Solde+1],
;
TABLE 2:
...
QTTERM as [Date Solde],
ETAT_DU_SOLDE as [Montant Solde],
Year(QTTERM) as [Année Date Solde],
Month(QTTERM) as [Mois Date Solde];
Actually, i've try this :
(1*) =sum( {$<[Année Date Solde]={[Année Date Solde]}, [Mois Date Solde]={[Mois Date Solde]={[Mois Date Solde+1]}>}[Montant Solde] ) (KO)
(2*) =sum( {$<[Année Date Solde]={[Année Date Solde-1]}, [Mois Date Solde]={déc.}>}[Montant Solde] ) (KO)
(2*) =sum( {$<[Année Date Solde]={2012}, [Mois Date Solde]={déc.}>}[Montant Solde] ) (OK) but I want a dynamique résultat)
What's wrong ?
Thx in advice & sorry for my bad English ^^
