Ask Your Question
0

How to repeat row labels in a pivot table

asked 2017-08-03 05:25:28 +0200

MaximusDecimus gravatar image

updated 2017-08-03 05:47:09 +0200

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-08-03 05:56:52 +0200

MaximusDecimus gravatar image

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
edit flag offensive delete link more

Comments

It works fine for me. Thank you.

Dwardo gravatar imageDwardo ( 2018-03-20 13:18:10 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2017-08-03 05:25:28 +0200

Seen: 868 times

Last updated: Aug 03 '17