Skip to main content
Question

Collapse columns total remains empty

  • April 11, 2023
  • 5 replies
  • 4495 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
 

 

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+1
  • Employee
  • 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+14
  • 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.