parent row %

[skinpup]

Hello

Apologies I have read the instructions for this on Microsoft help page a dozen times but I'm just not getting it and I can't find similar question on our site.
[TABLE="class: t1"]
<tbody></tbody>[/TABLE]

What setting in the drop down for 'show value as...' would give me the result job end/job start - for each row?

On the pivot table values box in field list I have a job start value and two job end values below that, thought I would be able to get the % of job ends and the actual number in two columns next to each other but I keep getting:

• the % of total job ends rather than job ends/job start
• column goes blank

[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]


[/TD]
[TD="class: td1"]Count of Job start
[/TD]
[TD="class: td1"] Count of Job end
[/TD]
[TD="class: td1"]Count of Job end2
[/TD]
[/TR]
[TR]
[TD="class: td2"]Leeds
[/TD]
[TD="class: td2"]200
[/TD]
[TD="class: td2"] 100
[/TD]
[TD="class: td2"]how do i get 100/200 as %
[/TD]
[/TR]
[TR]
[TD="class: td2"]Glasgow
[/TD]
[TD="class: td2"]94
[/TD]
[TD="class: td2"] 7
[/TD]
[TD="class: td2"]7/94 %
[/TD]
[/TR]
[TR]
[TD="class: td2"]Bath
[/TD]
[TD="class: td2"]16
[/TD]
[TD="class: td2"] 1
[/TD]
[TD="class: td2"]1/16 %

[/TD]
[/TR]
[TR]
[TD="class: td3"]etc
etc


[/TD]
[TD="class: td3"]

[/TD]
[TD="class: td3"][/TD]
[TD="class: td3"]

[/TD]
[/TR]
</tbody>[/TABLE]


What am I doing wrong?

Using excel 2010

 

[FormR]

getting somewhere now getting div/0 error!

Like this maybe?

=If('Sum of Start' = 0 , 0 , 'Sum of End'/'Sum of Start')

Or if not maybe you can post the formula you are using for calculated feild?

 

[skinpup]

i'm using the drop down option within excel 2010 selecting (end/start)*100

 

[FormR]

i'm using the drop down option within excel 2010 selecting (end/start)*100

To avoid the divide by zero error try:

=if(start=0,0,(end/start)*100)

You can omit the *100 part if you intend to later fornat as the cells as '%'

 

[skinpup]

WhoopWhoop! Thanks!

 

[FormR]

WhoopWhoop! Thanks!

Glad you got it working