2 Replies Latest reply on Sep 19, 2016 7:54 AM by David Li

    How to filter a max date of a primary table in a secondary table (data blending)

    Belen Pinuela

      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