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