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?
Many thanks
Create a calculated field with the formula INDEX(). Drag that to filters and set it to have a maximum of 1.
And check this link: Show me three highest results
maybe it will help.
Cheers
