How to get market data without Market field selection

[Lakshmanudui]

Hi All,

I have Data like Code , Market , Sales

Code	Market	Sales
1001	EAST	100
1002	WEST	250
1003	NORTH	150
1004	CENTRAL	100
1005	SOUTHEAST	50
1006	EAST	30
1007	WEST	80
1008	NORTH	90
1009	CENTRAL	70
1010	SOUTHEAST	100
1011	EAST	150
1012	WEST	250
1013	NORTH	200
1014	CENTRAL	450
1015	SOUTHEAST	250
1016	EAST	700

If I select 1001 code the Market is EAST sales is showing 100.

But my requirement is If I select Code is 1001 then total sum of EAST in Market field like 980.

Same thing like If I select 1015 then it is showing market is SOUTHEAST then I want to show Sum of Southeast Sales.

Can you please suggest me how to achieve this thing without selection of market field. Only selection of Code field.

Thanks & Regards,

Lakshman

[MarcoWedel · Accepted solution]

Sum({$<Code=, Market=p(Market)>} Sales)