HOWTO use summary values

[gazoller]

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

[wrightr]

For a given Fiscal Quarter,

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

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

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

[gazoller]

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

Thanks much!