QV - Expression - Aggr, Set Analysis, Only and Filters

[#1]

Hi! First of all, sorry for my English.

I can´t do something works.

I'm using a Pivot Grid and expressions with Aggr, Set Analysis and Only functions.

This is the data table.

%PCIID	PVIID	%CONCEPTO	PCIEstado	PVIEstado	Bultos
1		PEDIDOCLIENTE	Confirmado		100
2		PEDIDOCLIENTE	Confirmado		200
3		PEDIDOCLIENTE	Stand By		300
	1	PLANVENTA		Confirmado	100
	2	PLANVENTA		Confirmado	100
	3	PLANVENTA		Confirmado	50
	4	PLANVENTA		Confirmado	50

My original (it works) is to have the Sum of "Bultos" of "PEDIDOCLIENTE", so, i use: Sum(Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'}>} %Bultos),%PCIID))

Now, i added a filter "PVIEstado", but, i want to show the result of the original expression in spite of the value of the filter. So, i tried whith 2 syntaxis but it doesn't work. I tried with:

1. Sum(Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'},PVIEstado=>} %Bultos),%PCIID))
2. Sum({<PVIEstado=>}Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'}>} %Bultos),%PCIID))

How can id do?

Thanks

[Clever_Anjos · Accepted solution]

Try using both

Sum({<%CONCEPTO={'PEDIDOCLIENTE'},PVIEstado=>}Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'},PVIEstado=>} %Bultos),%PCIID))

[#3]

Perfect!! Thanks Clever!