Percentage by Subtotal by Row in a Pivot Table

[danaleota1]

Hello I created a pivot table where 

Site = Rows

Score = columns 

group by site

I'm trying to get a percentage of each score by individual site.  

I used this as my measure: 

Count({<[Net Promoter Score]-= {'Not Available'}>} [Net Promoter Score])/Count(Total {<[Net Promoter Score]-= {'Not Available'}>} [Net Promoter Score])

but I'm getting a percentage by the grand total across all sites and I want a percentage  by  individual row.  

Thank you.  

[sunny_talwar · Accepted solution]

Not entirely sure I understand what you are looking to do, but may be this

Count({<[Net Promoter Score]-= {'Not Available'}>} [Net Promoter Score])/Count(TOTAL <Site> {<[Net Promoter Score]-= {'Not Available'}>} [Net Promoter Score])

[danaleota1]

That's exactly what I needed.  Adding that dimension name was the missing piece.  I didn't know the syntax.  Thanks so much!