To filter expressions but not dimensions

[#1]

Hi, I have a problem that, siplified is:

I have the nex script to load data:

Clientes:

Load * ;

SELECT NombreCli,CodigoCli from Cliente;

Empresas:

LOAD * ;

SELECT CodigoCli,Empresa,Cantidad from Empresa;

In the document, I have a filter by Empresa, and a pivot table with CodigoCli, NombreCli as dimensions, and =sum(Cantidad) as expression. I want that the filter affects to expression, but I want see always the Code and Name of the customer. I only get that:

If I select a Empresa, I see the customer code, but not the name. How can I get the code and the name independently of the filter.

I attach a .qvw with the example.

Thanks.

[tresesco]

With a small trick, like attached:

[#3]

Thanks, it's a good solution, but I need a pivot table, not a straight table.

[tresesco]

Well:

=Only({1} Aggr(sum(Cantidad), CodigoCli,NombreCli))

[anbu1984 · Accepted solution]

Check this