How to Display Repeated Values in a pivot table?

TommyDenn

Running into an issue where a pivot table suppresses a repeated value while in a different group. In the image, I am needing the Care Level "CS" to display "Enhanced Studio" in the "Unit Type" column for unit 237. Currently it is suppressing since the above value is the same…

Anyone know how to do this?

Thanks!

DavidChurchman

Interesting, this appears to be a bug, which I was only able to reproduce with single-item groups like this (where the preceding entry is exactly the same). A handful of approaches (each with their own drawbacks):

1. If you check off "suppress single item subtotals", it will give the unit type (but you'll lose the formatted, repeated sub-total row, if that's important)

2. You can click the "Show all Group Names" button (but that applies to both the grouping columns, so a bit busy):

3. For this particular instance, you could sort by Move-in-Date instead of by Unit_Number, to separate your Enhanced Studios (but this might still have the same problem in the future, depending how the data changes)

4. You could use a MegaTable with Subtotals, instead of a Pivot Table, which only groups up to one level (but then you lose the Unit Type visual groupings)

5. You could concatenate something to guarantee the names don't match (but is slightly uglier/harder to read at a glance)

6. This isn't that much data, so I might ditch the table altogether an go for something more visual, that gives a better sense of trends:

DavidChurchman

Interesting, this appears to be a bug, which I was only able to reproduce with single-item groups like this (where the preceding entry is exactly the same). A handful of approaches (each with their own drawbacks):

1. If you check off "suppress single item subtotals", it will give the unit type (but you'll lose the formatted, repeated sub-total row, if that's important)

2. You can click the "Show all Group Names" button (but that applies to both the grouping columns, so a bit busy):

3. For this particular instance, you could sort by Move-in-Date instead of by Unit_Number, to separate your Enhanced Studios (but this might still have the same problem in the future, depending how the data changes)

4. You could use a MegaTable with Subtotals, instead of a Pivot Table, which only groups up to one level (but then you lose the Unit Type visual groupings)

5. You could concatenate something to guarantee the names don't match (but is slightly uglier/harder to read at a glance)

6. This isn't that much data, so I might ditch the table altogether an go for something more visual, that gives a better sense of trends:

TommyDenn

Thanks a ton for the thorough response. Several solid options mentioned. Will probably end up suppressing the single line values as it's most visually appealing.