Calculate group subtotal in repeatable table with drop down menus

[traskj]

Afternoon all:

I have a dynamic form with an expanding table format. There are nine columns and one of them has a drop down list of six items, the last column is a value.

I need to subtotal the six dropdown menu items separately- preferably in FormCalc.

The grand Total works just fine. 

It seems like it should be easy enough, but I'm stumped. Any help would be appreciated.

Thanks!

[Scott-Mc]

What's the criteria that triggers a subtotal to be needed?

[traskj]

I need the breakdown for records, but I don't want to make it a pain for users.

[traskj]

I may not have asked the question correctly. I have a drop down list with 6 items. The user fills in the quantity and rate after selecting the item. I can create a row value and a grand total value. What I need to do is display the group total for each drop down item ina  separate box.

I cannot figure out how to reference the dropdown item. The menu list is tied to Cell3. I get this far, and then I am stumped.

Sum(Table1.Row1.Cell3[*].Cell9[*])

[traskj]

This code pulls out the value perfectly on the first row, but does not work on the repeating rows. What am I missing?

If(Table1.Row1.ddl[*] == "1" )then Sum(Table1.Row1.Cell9[*])

else $ = 0

endif