This content has been marked as final. Show 2 replies
I have got a primary table, which contains the Budget for the complete year, and a secondary table which contains the real data.
I want only to see data of max(date) of the secondary table and to show only those data.
It is not valid for me to define primary an secondary table in the data blending the other way around because at the level of aggregation needed, in many cases we do not have real data (sales),so it would seem that the Budget has been fulfilled when it hasn't.
I have tried different formulas with max date from the secondary table but the max(date) of the secondary gives errors when trying to include in all the formula attemps I've learnt.
Does anyone know how to get it?