I need help filtering a portal to show only unique values.
I have the following relationship:
I have a portal in "procedimiento_PROCEDIMIENTO_all" layout showing all records from "PROCEDIMIENTO". It is self join relationship showing all records in that table. Then, I filter this portal with the following calculation:
I can't filter the portal through relationship as "c_status_filtro_Fase_procedimiento" and "c_status_filtro_Accion_requerida" are unstored calculation fields.
Until now, everything works just great. The portal is filtered just fine. This is how it looks like once filtered:
The fields marked in green are from "c_status_filtro_Fase_procedimiento" and "c_status_filtro_Accion_requerida" used to filter the portal.
THE PROBLEM: I need to filter the field marked in yellow in the portal so that, no duplicates show up, only unique values. This is another calculation field showing the following numbers: 6, 8, 10 and 13 when the portal is filtered with the previous calculation.
I found several solutions that involve filtering the portal through relationship and some filter calculations. I can't filter the portal through relationship as the match fields would be unstored calculation fields.
I also found this Grouping portal rows connected with hiding doubles. where there is a solution with a filtering calculation but I don't t seem to make it work for my solution.
Can anyone help me with this?
Thank you all in advance!