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

[vishsaggi]

In your straight table chart Remove Document No_ from your dimensions and add

expression as

= Sum(BOMITEMQty)

[el_aprendiz111]

Hi,

sum(TOTAL BOMITEMQty)

[sergio0592]

Just use two text box:

left text box =GetFieldSelections (BOMITEM_Description)
right text box= sum(BOMITEMQty)

[nedcliqs]

Thanks Vishwarath, unfortunately i still get a 6

[nedcliqs]

Tried it, thanks, but still getting a 6 instead of 36

[Anil_Babu_Samineni]

Where are you trying this?

[nedcliqs]

Thanks Jean, Description pulls correctly but sum(BOMITEMQty) gives a 6

[nedcliqs]

All the above suggestions, i have tried on a straight table. Jean's one, i have tried on a Text Object

[sergio0592 · Accepted solution]

And if you try with :    sum( AGGR(sum(BOMITEMQty),Document_No) )