Hey,
We created a report in Report studio and I grouped on Project name query item . when I ran the report it is giving both detailed values as well as summarized values as follows
projectname profit revenue cost
AA 12 13 222\------detailed values
1 14 225/------detailed values
total 13 27 447-------summrized values
but as per our requirement it has to display as follows
projectname profit revenue cost
AA 13 27 447 ------summarized values only for that particular group in single line
When I enable the aggregation as total it is displaying total for that grouped query item in multiple
lines but I want it in single line as mentioned above.
How can I solve this issue.
Hi,
Assuming ProjectName is the only non-measure item in your report, and you have Auto Group and Summarize turned on, you should get the result you are looking for without having to group manually on ProjectName.
If I were you I would go to the properties of the query and check that the Auto Group and Summarize property is set to 'Yes'. If it is, then there is something else odd going on - probably best to look in Framework Manager at the properties of the Query Items you are using.
Let us know what you find.
Regards,
MF.