1-Visitor

Question

how to do sum quantity seperately for eachpartnumber

Greetings everyone!!

I know how to sum the whole table qty. But all I need to know is how to sum up the qty for each part number in the table.

As in the pic, I need to calculate the sum for “BK-16-GXL” in the qty coloumn .I've attached a snap for ur reference...KIndly help me

do i need to use any relation or modify repeat region options ? Let me know

Author

1-Visitor

23-Emerald III

Go to TABLE - REPEAT REGION - ATTRIBUTES - NO DUP/LEVEL

Author

1-Visitor

thank u for ur reply stephens... @stephens williams

in repeat region there is a option to add the total quantity by "SUMMATION"

In that we can add the total quantity and get the answer in single cell.

but i want to add seperately for each color

for example

i want to sum up "BK-16-GXL" qty as 83.95+152.312+185.403 in a seperate cell...

21-Topaz I

If summation works then maybe you should just do multiple repeat regions for each part with a filter.

Author

1-Visitor

thank u christopher...

but if u never mind...could u please explain elaborately... i cant understand plzzz

Sign up