Sum of Rows

[nedcliqs]

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

[Anil_Babu_Samineni]

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

[nedcliqs]

Thank you very much @  jean-baptiste‌, the Aggregation function. Not only on the Text Object, but also on the Straight and Pivot tables

[nedcliqs]

sum( AGGR(sum(BOMITEMQty),[Document No_]) ) as suggested by @ Jean-Baptiste RENAULTworked

Thank you all for your help.