Hello i have created a Report to see the Sales Orders, Sales Order Items, Good Issue Date and the net value.
In my Cube view i defined the net value with @DefaultAggregation: #SUM which should sum up the net value.
In my story i display the good issue date in hierarchy (YEAR-MONTH-DAY) or drilling to see the months.
The problme is
i have on day 19.09 -- 14 different positions and i see the toal value of SUM on month but also on the day 19.09 but it is wrong.
Each value is calculate * 30 i guess for the month..
I am expecting the sum only from the net values -- so no multiplication just the sum of all rows of all salesorderitems but it does not work with this single field set as @DefaultAggregation: SAP Summit
Please can one shed some light into it.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.