Max value of a dimension aggregated by another dimension

[afbraga1]

Hello,

As of late, I've been trying to create a table which gives me the max value of a material regardless of the customer. If I don't make filters it works flawlessly, but when filtering it the scope changes and I it adapts to to that.

Below is the table without filters:

If I filter by material it works as I want. Image below:

But when I filter by Customer(image below), I don't get want I want, since wanted to see for A-500, B-1000, C-200.

I understand why this happens, but it's not what I want.

Is there any way to achieve what I am portraying here?

Thanks in advance,

André Braga

[chanin7893]

Thanks a lot man.

[sunny_talwar]

No problem