I am loading data to cube 0pur_c01 i which i have added the keyfigure 0netprice & mapped it with 0netprice infoobj ,but my report is dsiplaying the wrong results
Data for particluar material in RSA3
DocDate Tranfer Purch.Doc Material Quantity Net price
process
05.01.07 4 55036 10000051 2,040.00 78.98
05.01.07 2 55036 10000051 -2,040.00 78.98
05.01.07 2 55036 10000051 2,040.00 78.98
05.01.007 2 55036 10000051 -2,040.00 78.98
05.01.07 2 55036 10000051 2,040.00 78.98
05.01.07 2 55036 10000051 -2,040.00 78.98
05.01.07 2 55036 10000051 2,040.00 78.98
05.01.07 2 55036 10000051 -2,040.00 78.98
05.01.07 2 55036 10000051 2,040.00 78.98
05.01.07 2 55036 10000051 -2,040.00 78.98
05.01.07 2 55036 10000051 2,040.00 78.98
05.01.07 2 55036 10000051 -2,040.00 78.98
05.01.07 2 55036 10000051 2,040.00 78.98
In my report it is showing me
Qty = 2040 Netprice=
Material DocDate Quantity
10000051 05.01.07 1026.74(78.98*13) i.e there are total of 13 records in rsa3 so it is adding up and giving the sum of all netprice for this particular material
instead my report should show me
Material DocDate Quantity
10000051 05.01.07 78.98