Percentage Sub Total 1

[davida37]

Hi,

I am using SQL Server 2005 and SSRS.

I have a report which has percentage(%) columns. the report also has sub groups.

My problem is that the sub total is totalling my Percentages - like a sum. I need the sub total to act as a overall % . I.e. the answer should be 90% not 179%.

Emails Hits %
100 89 89%
100 90 90%
200 179 179% 90%

Please help. thanks
David

 

[xlbo]

Remove the "SUM" from the subtotal formula

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[davida37]

Hi. that doesnt work. It just takes the previous lines Value instead of the the sum for the site.

Site Name EmailsPushed Hits Delivered PC
A 200 50 15.00% ----- SubTotal Line
100 15 15.00%
100 35 35.00%

thanks

 

[davida37]

I found this - and following these instructions it help and I worked it out.

http://forums.databasejournal.com/archive/index.php/t-38371.html

Thanks!