Print Page - HOWTO use summary values

Title: HOWTO use summary values
Post by: gazoller on 13 Nov 2007 12:02:24 PM

Goal: Show units and % units

For a given Fiscal Quarter, I want to show units sold and % of total units by product
E.g.
Product_A: Units = 20, %Units = 20%
Product_B: Units = 25, %Units = 25%
Product_C: Units = 25, %Units = 25%
Product_D: Units = 5, %Units = 5%
Product_E: Units = 25, %Units = 25%
Total(Product): 100

As I understand it, and the way my aggregation option is set, Total(Product) evaluates to Total([Units] within detail [Product]). If I try to use Units / Total(Product) I get an error about cn node expected to be a value, which I interpret to mean I don't have an actual value to work with.

How do reference the value of Total(Product) in my %Units calculation? I'm sure this is something easy that I am missing...

Thanks
Garth

Title: Re: HOWTO use summary values
Post by: wrightr on 13 Nov 2007 02:21:15 PM

For a given Fiscal Quarter,

[TotalUnitsByProductByQtr] = total([Units] for [Product])

[TotalUnitsAllProductAllQtrs] = total([Units] for report)

[PctUnitsByProduct] = 100*([TotalUnitsByProductByQtr]/[TotalUnitsAllProductAllQtrs])

Title: Re: HOWTO use summary values
Post by: gazoller on 13 Nov 2007 02:51:46 PM

Perfect, works like a charm. total([Units] for report) was the piece of information I was missing.

Thanks much!

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: gazoller on 13 Nov 2007 12:02:24 PM