Please check if fits your needs
(ooxml, embedded labels, table is Data);
Order_Year as Aux,
Aux as LastPurchaseYear
Where Aux < Order_Year;
Howdy! I have attached a sample QVW, Pretty confused on this inter-record stuff.
For each transaction, i need to calculate the last year (Prior to the year of that transaction) that there was a transaction.
CustomerLastPurchase_Year.qvw 162.0 K