title: Fill blank cells in pivot table as a reference to a value above
body: <p>Messing with a pivot table and its behaviour. I have many categories describing each row, but for my own needs, I want to have every row's cell filled regarding its category. Not to have blank cells, as default, refering category name's cell. </p>
  
  <p>For example given below, desired solution is to fill A6-A24 with value from A5 and then category changes to e.g. ,,Region Detail" and the blank row's filling changes too to ,,Region Detail" (you can simply imagine it in DATE_KEY column). Any methods?</p>
  
  <p><a href="https://i.stack.imgur.com/OdlFN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OdlFN.jpg" alt="enter image description here"></a></p>