How to repeat row labels in a pivot table

[MaximusDecimus]

I have this data

DATE           YEAR(fx)      MONTH(fx) PRICE
2013-01-15     2013              1       3.5
2013-01-20     2013              1       4.5
2013-01-22     2013              1       6.5
2013-01-23     2013              1       1.5
2013-02-15     2013              2       2.3
2013-02-20     2013              2       3.4
2013-03-11     2013              3       234.5
2013-04-05     2013              4       35.0
2013-05-14     2013              5       3.99
2013-05-23     2013              5       3.5
...
2017-07-02     2017              7       15.98

I created a pivot table where Rows are YEAR and MONTH and data is SUM - PRICE

A pivot table was created like this

YEAR  MONTH   SUM_PRICE
2013      1         15.65
          2          5.7
          3        234.5
          4         35.0
2014      1          XX

But I want to repeat the year per each row automatically like this

YEAR  MONTH   SUM_PRICE
2013      1         15.65
2013      2          5.7
2013      3        234.5
2013      4         35.0
2014      1          XX

Instead to copy and paste the year in the empty cells anytime the pivot table is refreshed. How can I do that?

[MaximusDecimus]

I found it

• Right click anywhere within pivot table
• Select Edit Layout
• Double click on Year (in my case) from Row Fields list
• Data Field popup will be opened.
• Click on Options button
• Data Field Options popup will be opened.
• Check option Repeat item labels
• Ok, ok, ok

[Dwardo]

It works fine for me. Thank you.