I have created for my user a crosstab report that represents a summary of average test times for electronic components. The attributes are:
QuoteCOMPONENT, WEEKTEST BEGIN DATE, TEST NAME, AUTOTESTER SOFTWARE VERSION, TEST TIME IN SECS, AVG TEST TIME IN SECS
This is my crosstab layout
QuoteWEEKTEST BEGIN DATE
COMPONENT TESTNAME AUTOTESTERSW TOTAL(AVG TEST TIME IN SECS)
TOTAL BY COMPONENT
When I add a total to my report, It adds all the records for average test time() as you would expect. However my user wants the total to be for Test Time In Seconds instead.
I tried modifying the Total calculation from "total(currentMeasure within detail [COMPONENT])" to "total(currentMeasure within set [COMPONENT])" but the results made no sense.
I also tried changing the calculation to "total(currentMeasure within set [TEST TIME IN SECS])" but it failed: Report Studio threw an error because this attribute is not in the report (even though it is in the query).
Can this be done at all?
Cognos Report Studio 8.4
IBM DB2 UDB
Thanks in advance for your help.