CODEWITHSUNDEEP
reporting-services
HelenS
HelenS

Reputation: 31

SSRS adding a percentage column which gives a percentage of the total

I have an issue with SSRS I hope is really simple to solve. What I have is a matrix which currently looks a bit like this:

Just numbers

There is a parent row group applied grouping them numbers according to item.

What I'm hoping to do is add a column to the right giving the percentage of the total applied to each item. So the output I'm hoping for looks something like this:

Numbers and percentages

I'm just not sure how to get to this point although it seems like it should be pretty simple. I have tried putting an expression in saying something like:

=100*IIF(Sum(Fields!count_b.Value)=0, 0, Fields!count_b.Value/sum(Fields!count_b.Value))

But it doesn't produce the desired result because the 'sum' part is grouped according to the row group.

Apologies if I'm being incredibly dense...!

Many thanks in advance for your help.

Edit : format code

Upvotes: 0

Views: 1359

Answers (1)

HelenS
HelenS

Reputation: 31

Never mind I have arrived at an answer! For anyone reading this who is also wondering, I tried: =100*IIF(sum(Fields!count_b.Value, "dataset")=0, 0, Sum(Fields!count_b.Value)/sum(Fields!count_b.Value.Value, "dataset")) - this solved my problem.

Upvotes: 1

Related Questions