title: % of Row Total in pivot table
body: <p>I'm trying to format my pivot table values as percentages of their row totals (in my data, each quarter). However, when I select Show Values as % of Row Total, it gives each value 100%.</p>
  
  <p>When I try Show Values as % of Parent Row Total, it uses the column as the total and uses the first 4 quarters of 2017 as % total of 2018, not at all what I want to do. </p>
  
  <p>Here is my current pivot table
  <a href="https://i.stack.imgur.com/h5TSZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h5TSZ.png" alt="enter image description here"></a></p>
  
  <p>Here is how I'm trying to format the same pivot table
  <a href="https://i.stack.imgur.com/KmzaI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KmzaI.png" alt="enter image description here"></a></p>