Querying a report

[funkmonsteruk]

I have had a problem with a report that i'm producing, basically for every <Value> there is a <description> and i want to sum all the <Value>'s. However I don't want to include the individual <value> or the <Description>'s if i remove the <description>'s from the report it ignores any duplicate <value>'s which is leading to an incorrect Sum<Value> figure being returned.

Is it possible to query a report which has all the elements required to give a correct response, so as i can on abstract the variables which i require?

 

[blom0344]

Possible answer in your original thread.....

I hope... T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[promero]

If I'm correct, your <value> object is a dimension or a detail, not a measure. The <value> object in the universe must be defined as a measure that uses the Sum function for aggregation.