How to Display Repeated Values in a pivot table?

TommyDenn
TommyDenn Member
in Cards, Dashboards, Stories

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?

DOMO Forum.png


Thanks!

Tagged:

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    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)
    image.png

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

    image.png

    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)

    image.png

    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)

    image.png

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

    image.png

    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:

    image.png
    image.png
    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    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)
    image.png

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

    image.png

    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)

    image.png

    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)

    image.png

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

    image.png

    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:

    image.png
    image.png
    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • TommyDenn
    TommyDenn Member

    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.

Categories