Hi,
I need expert help to solve below problem.
My data in table 'mytable' look like:
customer country month cost c001 US 201506 -100 c001 DK 201506 -100 c001 DE 201506 -50 c001 FR 201507 -200 c001 UK 201507 -50
I need to get below results:
customer country month cost
c001 DK 201506 -100
c001 FR 201507 -200
that is 'within each month', taking 'hightest cost' generating 'country' for each customer.
CATCH: in this example, we can see that in 201506, cost -100 is same for US and DK. In this case only taking either one, not both.
Thanks for your help.
Regards
Nomann