Percentage in pivot table ingnoring a dimension out of 3

[shrutipg]

Hi 

i need to calculate percentage with respect to 2 dimensions 

dev site from table A

market from table B 

and error type from table C 

while calculating measure dimension error type needs to be ignored 

refer below image 

I should get denominator same for a dev site in a market 

so dev site A in market CA should have same value in denominator irrespective of error type 

currently denominator is same for all market and all dev sites. 

count(distinct [PJT.Project Code])&'/'&   ---> numerator 
count(total <[PJT.Development site],[CNTRY.Market]> distinct [PJT.Project Code])    ---> Denominator 

Please advise 

[Ksrinivasan]

hi,

pl. provide your expected result.

i cant get your expected result from your ticket description.

ksrinivasan.

"clear explanation about requirement will get always immediate solution"

[shrutipg]

I should get denominator same for a dev site in a market 

site A in Market CA --> all error type should have same denominator 

            A 

CA :    1/5

             2/5

             2/5