Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
In Excel pivot table, is it possible to have the table repeat the item that is being summarized on every row?
So let's say I have this:
Month____Acct_____Sales
Jan..........1234.........5000
Jan..........1234.........2000
Jan..........6789.........1000
Jan..........6789.........3000
If I do a pivot table with Month as the 1st column and Acct as the second column, can I get Excel to display it like this?
Month__Acct___Sales
Jan.......1234.......7000
Jan.......6789.......4000
What I get instead is this (i.e. without the second "Jan"):
Month__Acct___Sales
Jan.......1234.......7000
............6789.......4000
I have Excel 2002.
1 Answer
- 1 decade agoFavorite Answer
I use Excel 2003 and have attempted this with Excel 2007 as well, and I don't see a way to execute that setting with the features of the PivotTable. You can, of course, paste the resulting PivotTable into a new sheet and modify the "missing" values yourself.
If there is a way to automate this within the PivotTable using VBA, I'm not aware of it.
