Datawindow Subotal Issue

[computergeek]

Hello,

I am trying to modify a datawindow report to contain subtotals at sphere. The result set (sql) behind the dw contains both detail and summary information.

sphere project resource skill summary_manhrs (for project)
dept1 abc1 res1 skill1 220
dept1 abc1 res2 skill2 220
dept1 efg1 res4 skill3 50

Within the report the manhours totals should be 270, but its is reported as 490. Is there any way of summing only the first record for dept/project?

Thanks in advance for your thoughts,

Computergeek

 

[mbalent]

You could create a group in the dw so your totals are shown appropriately.

Matt

"Nature forges everything on the anvil of time