Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
I have rows of data for an item but from different sales orders
Since the item description is the same, i want one line (in a straight or pivot table) that will give me the a total sum for this item
The correct quantity for the above should be 36
May you please help on how i can have something like (Using a calculation)
BOMITEM_Description TOTALQUANTITY
Zipper Bag 36
If you have only one dimension and that dimension used for aggr in measure you will always get 6.00
Use document number field also within the aggregation to work
Thank you very much @ jean-baptiste, the Aggregation function. Not only on the Text Object, but also on the Straight and Pivot tables
sum( AGGR(sum(BOMITEMQty),[Document No_]) ) as suggested by @ Jean-Baptiste RENAULTworked
Thank you all for your help.