Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to make a table graph, which shows me the ID_FORNITURA and ID_DOCUMENTO fields, inside there is a DATE field which also contains the historical data with old data, I need to have a table which contains only the latest ones, i.e. the current ones with the last date, how to do?
I did that, but it doesn't work:
on dimension i put: id_documenti, id_fornitura
on expression i put: =Max(T_FATTURE_SINTESI_ST.DATAFOTO)
but in this way i see the data OLD too, i want to show only the record have, in this example, the date 16/07/2023
Like this.
=Only({$<datafoto= {"$(=Max(datafoto))"}>}datafoto)
This work, thanks, but can you explain to me what did you do?
Thanks