Issue with data

[Anonymous]

Hello all,

I have 2 qvds (traffic – sales) where I take the data for my table (I attach sample data)

For the TRAFFIC_PLACE= FOA in the qvd where I take the traffic I don’t have ID_WAREH and MOVE_TRKIND

and for that reason when I sum(sales) it doesn’t bring me anything.

Also when I choose something from the box MOVE_TRKIND it disappear.

In order to have the right amount of sales, I have to choose from the MOVE_TRKIND= ΔΕΛΠ , ΔΛΠ

and I want my table to bring me for the  TRAFFIC_PLACE= FOA the sales of the ID_WAREH=291,322,543

I want to be like this:

                                                                                                                                                                                                                MOVE_TRKIND

TRAFFIC_PLACE	ID_WAREH	WAREH_STNAME	Traffic	Sales
Bazaar Ag. Stefanos	566	Outlet Έδρας	12	182
Calvin Klein GH	564	Calvin Klein Golden Hall	0	11
Calvin Klein The Mall	563	CK Jeans Mall	19	99
Collective Glyfada	367	Collective Γλυφάδας	29	364
Collective Kolonaki	649	Collective Κολωνάκι	70	495
Collective N. Erythrea	138	Collective Ν.Ερυθραίας	46	396
FOA	-	-	690	5.362
Collective Psichiko	707	Collective Ψυχικού	53	569
GRE001	29	Nike Γλυφάδας (Βουλιαγμένης)	292	4.406
GRE002	14	Nike Ψυχικού	172	1.149
GRE005	46	Nike Κηφισιάς	92	948
GRE006	1135	Nike Πάτρας	227	884
GRE007	471	Nike Ν.Ερυθραίας	110	811
GRE008	155	Nike Πειραιά	134	557
GRE011	34	Nike Καλλιθέας	118	829

-

ΔΕΛΠ

ΔΛΠ

ΔΛΠ-TF

Thank you very much for your help!