Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum({$<Code=, Market=p(Market)>} Sales)
Sum({$<Code=, Market=p(Market)>} Sales)