Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sum Issue

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.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question