pivot table issue % of sub totals

[sreenivas123]

Hi All,

I have below requirement,

At present pivot table  shows  sub total of compliance %= Incomplete+Late+Ontime,

But, I want to show sub total based on  below calculation.

Sub total formula of compliance % by course status  column= (Ontime) /(Ontime+Late+Incomplete)*100

		MonthBucket	Mar 2016
Organization	Course Status	Compliance %	90.77%
Breast and Skeletal Health Organization	Incomplete		2
	Late		88
	Ontime		721
	Compliance %		811
Commercial Operations	Ontime		66
	Compliance %		66
Corporate Business Development Organization	Ontime		1
	Compliance %		1
Corporate Finance Organization	Incomplete		1
	Late		3
	Ontime		127
	Compliance %		131
Diagnostic Organization	Incomplete		8
	Late		37
	Ontime		369
	Compliance %		414
Human Resources Organization	Late		1
	Ontime		11
	Compliance %		12
Information Services Organization	Late		8
	Ontime		49
	Compliance %		57
International Organization	Incomplete		45
	Late		49
	Ontime		847
	Compliance %		941
Legal Organization	Incomplete		5
	Ontime		11
	Compliance %		16
Regulatory and Quality Organization	Incomplete		1
	Late		45
	Ontime		428
	Compliance %		474
Supply Chain Organization	Incomplete		7
	Late		104
	Ontime		1361
	Compliance %		1472
Surgical Organization	Incomplete		1
	Ontime		113
	Compliance %		114

Is it possible, if possible any one can help me to show  subtotal based on calculation.

below is example file.

Thanks.

[Anonymous]

Can you please try something like below in your expression.

=If(Dimensionality() = 1, (Ontime) /(Ontime+Late+Incomplete)*100, <The expression you used>).

[sreenivas123]

i have tried same way(below is expression) , but not working.

Used expression as

if(Dimensionality()=1,

Num(Aggr(sum(aggr(Count(DISTINCT{<Bucket={Ontime}>}Employee_Number),Org_Hier.ORGANIZATION, Bucket,Complaince_Training_Program, MonthBucket)) /

Sum(Aggr(Count(DISTINCT Employee_Number),Org_Hier.ORGANIZATION, Bucket,Complaince_Training_Program, MonthBucket)), MonthBucket),'#,##0.00%') ,

sum(aggr(count(DISTINCT Employee_Number), Complaince_Training_Program, Org_Hier.ORGANIZATION, Bucket, MonthBucket )))