I already tried to solve the problem using three different approachs.
. Using the LOOKUPVALUE function
. Using an X function after using the SUMMARIZE function
. Using an X function after using the FILTER function with the ALL
I wasn´t able to get what I want.
Could you give me some clues that can help me?
The attachment image shows what I have and what I want to obtain.