How to get market data without Market field selection

Lakshmanudui — Mon, 23 May 2022 05:24:07 GMT

Hi All,

I have Data like Code , Market , Sales

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

Re: How to get market data without Market field selection

MarcoWedel — Mon, 23 May 2022 06:19:10 GMT

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