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_documento, id_fornitura, datafoto
but in this way i see the data OLD too, i want to show only the record have, in this example, the date 25/06/2023