Skip to main content
Solved

Collapse columns total remains empty

  • April 11, 2023
  • 5 replies
  • 4515 views

Oliver
Wallflower
Forum|alt.badge.img+1

Hi, 

I have an issue regarding the behaviour of the new expand/collapse columns feature.

When I have a summary set to the dimension I want to collapse (Month>Year : LAST for example). If I collapse this dimension the Total column remains empty while it is well displayed when expanded.

Do you know why and how to solve this?

 

Thank you
 

 

Best answer by Fabien

Good morning,
if you open the pivot tab, would you actually have the scenarios set at the bottom of the column list ?
If so, could you set it at the top of the column list and check if it solves the issue ?

If you confirm, I’ll raise the point to the product team.
Thanks

5 replies

Forum|alt.badge.img
  • Apprentice Author
  • October 5, 2023

Hi @Oliver - I have the same question. Were you able to resolve this issue? Thanks!


Fabien
Employee
Forum|alt.badge.img+3
  • Employee
  • Answer
  • October 6, 2023

Good morning,
if you open the pivot tab, would you actually have the scenarios set at the bottom of the column list ?
If so, could you set it at the top of the column list and check if it solves the issue ?

If you confirm, I’ll raise the point to the product team.
Thanks


  • New Here
  • March 4, 2025

Has anyone figured out a solution to this? I am having the same problem and can’t figure out a solution.


CDALMAY
Master Helper
Forum|alt.badge.img+15
  • Master Helper
  • March 4, 2025

Hi ​@DerekKramer,

​​What ​​​​@Fabien suggested should be the solution :

If you’re using Scenario, they should be on top of the columns even if they’re not displayed, like the example below :

 

Let us know if that helps,


  • New Here
  • March 4, 2025

Mine are happening in rows actually. my columns were set the same way. I want the highlighted cells to show the roll-up of all below numbers. I can only get the totals up top if I put my metrics up top but want the highest roll-up to be special project names.