ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table - can all row titles alway show up? (https://www.excelbanter.com/excel-discussion-misc-queries/152422-pivot-table-can-all-row-titles-alway-show-up.html)

roadkill

Pivot Table - can all row titles alway show up?
 
I have a pivot table where the columns are weeks, the rows are activities,
the page selection is a person's name and the data area contains the # of
hours. Is there a setting that will cause the pivot table to always show all
rows (i.e. activities), even if there's no data for some activities for a
given person? I thought I had stumbled across such a thing a few months ago
but sure can't find it now (was I dreaming?).
Thanks,
Will


All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com