Skip to Content
0
Former Member
May 15, 2010 at 08:39 AM

About Restriction key figures

23 Views

Dear all,

Following is my situation, For example,this is cube data

Plant Material Number Quantity

P001 1001 10

P002 1001 20

P003 1001 30

P001 1002 30

But My Report want to Add new column (P001 Quantity) ,and result is like this:

Plant Material Number Quantity P001 Quantity

P001 1001 10 10

P002 1001 20 10

P003 1001 30 10

P001 1002 30 0

I have used Restriction key figure to add new key figure to fiter P001,but Result is like this

Plant Material Number Quantity P001 Quantity

P001 1001 10 10

P002 1001 20 0

P003 1001 30 0

P001 1002 30 0

Hope somebody help me,thks