Pivot Table Collapsing

stephen_wall
stephen_wall Member
in Charting

Hi all,

I used to have this card setup so the pivot table was expanded out one level and it worked fine up until a month ago. When I view the card all levels are collapsed in the dashboard view. If i go into the card to expand it out and click save, it keeps defaulting back to a fully collapsed view. This didn't happen previously and I've tried resetting the table properties but still having the same issue - am i missing a step now?

image.png

When i click save it collapses everything.

image.png

TIA!

Steve

Tagged:

Best Answer

  • brycec
    brycec Contributor
    Answer ✓

    Have you tried saving as and seeing if a new card would save correctly or trying to create the card from scratch? You're right, it should allow you to save the card with the subtotals collapsed or expanded. But sometimes cards get messed up and restarting from scratch fixes it.

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

Answers

  • brycec
    brycec Contributor
    Answer ✓

    Have you tried saving as and seeing if a new card would save correctly or trying to create the card from scratch? You're right, it should allow you to save the card with the subtotals collapsed or expanded. But sometimes cards get messed up and restarting from scratch fixes it.

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

Categories