How to add percent for columns

# How to add percent for columns

• Sunday, September 16, 2012 11:30 AM

Hi All,

I need to have cumulative percent across my columns

Below is my report outline and report output

I need cumultiive percent between A/B

followed by B/C followed by C/D and so on

hence the column will be

Total Application

A

B

A/B percent

B

C

B/C percent

C

D

C/D percent

and so on

Any helpon this will be greatly appreciated

Thanks

• Edited by Sunday, September 16, 2012 1:51 PM 1
•

### All Replies

• Sunday, September 16, 2012 12:40 PM

Hi,

Could you just clarify a little.  Calculating the ratio of A->B, then B->C and so on is simple enough for any given row, but where are you needing the cumulative totals?

If you're talking about cumulative in terms of advisors going down the table, you could use the runningTotal function in SSRS to sum A for all advisors so far and the same for B, then divide one by the other for the ratio.

It might be easier depending on exactly what you're after to perform an unequal self join in the SQL dataset to get the running totals you're after.  There's a nice example of running totals here:

http://stackoverflow.com/questions/2529367/can-somebody-explain-the-running-total-and-sql-self-join-in-this-tutorial-to-me

If you could clary withe regards to exactly what data is being totalled and where the calculations need to be performed I may be able to help further.

Regards

James

• Sunday, September 16, 2012 1:45 PM

Hi James;

i just need the ratio A/B in percent , B/C in percent and so on that the heading

but this field is dynamic which is called new_evidenceforoutputidname

• Sunday, September 16, 2012 2:23 PM

I see what you're getting at.  I think we can do it.

Don't worry about the new dynamic field name new_evidenceforoutputidname, you just need to put an expression in the header:

I think you can just use = count(claimPeriodB)/count(claimPeriodA) to get your ratio.  It should total all the entries for all the handlers for each claim period.

Regards
James

• Sunday, September 16, 2012 3:39 PM

but claim period A, B,C... are dynamic as well count(new_claimperiodidname)

• Sunday, September 16, 2012 8:29 PM

Hi Simran,

Apologies, I thoguht we were looking at a table, not a matrix arrangement.  I've just had a look around and found this post essentially gives the answer: