I'm using straight table and I have a problem with calculation "Total Qty" - the formula should be sum(Qty) grouped by Code.
Can anyone help me with set analysis formula?
See this sample may be it help you!!
i don't know what you expect result. i thought you need total qty in all rows.
use this for total qty for each row
Ex: Sum(TOTAL [Total Qty])
Try sum(total <Code> Qty)
Retrieving data ...