Skip to Content
0
Former Member
Sep 17, 2014 at 06:52 AM

Sum Issue

16 Views

Hi Expert,

I have two queries

Q1: Country, Date1, MeasureA

C1 , 2014-01-01, 70

C1 , 2014-02-01, 10

C2 , 2014-03-01, 150

C2 , 2014-01-01, 50

Q2: Country, Date2, MeasureB

C1 , 2014-01-01, 30

C1 , 2014-02-01, 40

C1 , 2014-06-01, 20

C2 , 2014-03-01, 170

C2 , 2014-04-01, 60

And I want to get following result;

Country | MeasureA | MeasureB (Only Date1 return)

C1 , 80 , 70

C2 , 200 , 170

I merged both Date1 and Date2 and create a variable =sum(MeasureB) in ([Date1]), but still give me total figures from measuresB.

Experts, any clue to resolve this.

Many thanks.