losing value of sum when moving to crosstab

[snshgrdn]

I have tried the "avoid duplicate rows in aggregation" format for table, but when I use the variable in another report the duplicate lines do not calculate correctly.

Line 1 20.16
Line 2 21.10
Line 3 20.16

Answer should be 61.42, and it is - until I try to use the sum value in another table in the same report that does not have the column header that forces them to be different (in this case, the line #)value is 41.26.

How can I get the correct value to display in all tables?

 

[blom0344]

Hello snshgrdn,

You do not give a clue over which dimension (s) you are aggregating , but in my experience calculating problems can sometimes be solved by adding extended context in cases where it should not be needed. So if you aggregate over dimension XXX try something like:

= Sum(<measure>) in <XXX> T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com