You might check the SUM / CALCULATE syntax. You may also look at associating an INDEX with the "GROUP" codes.
>I have this project and it requires the calculation of profit/loss for a company. What they want is to have a certain number of records marked by a code listed on a grid. At the end of those records, they want a summary line item showing the calculation for those items (indicated by a NULL or X to show it is a summary line). Then of course for the process to continue with another group code and it's summary line item.
>
>Now my first thought was to add summary entries into the table which house the group codes. However, it does not work too well that method. I am having trouble seperating the group codes by the summary line. Then I figured on creating a new table to only hold the summary descriptions, but no go there. I could be wrong in the way that I am going about this. Example below:
>

>DESCRIPTION      CODE    AMOUNT
>
>DVD INCOME       410     50000
>DVD LOSS         510     10000
>GROSS DVD INCOME NULL    40000
>VHS INCOME       420     50000
>VHS LOSS         520     60000
>GROSS VHS INCOME NULL    -10000
>ADMINISTRATIVE   610     40000
>SALES            710     30000
>TOTAL OFFICE     NULL    70000

>
>Any suggestions would be helpful. Thanks!