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
And if you try with : sum( AGGR(sum(BOMITEMQty),Document_No) )
In your straight table chart Remove Document No_ from your dimensions and add
expression as
= Sum(BOMITEMQty)
Hi,
sum(TOTAL BOMITEMQty)
Just use two text box:
left text box =GetFieldSelections (BOMITEM_Description)
right text box= sum(BOMITEMQty)
Thanks Vishwarath, unfortunately i still get a 6
Tried it, thanks, but still getting a 6 instead of 36
Where are you trying this?
Thanks Jean, Description pulls correctly but sum(BOMITEMQty) gives a 6
All the above suggestions, i have tried on a straight table. Jean's one, i have tried on a Text Object
And if you try with : sum( AGGR(sum(BOMITEMQty),Document_No) )