Pivot tables "un-freezing" columns in Rows values

Follow

Alfonso Moran

March 24, 2020 02:12

When adding fields to the Rows section in a Pivot table, those columns become Frozen, so when you scroll to the right to see the next values, the first columns do not move. Is there are way to "Un-Freeze" these first columns? (maybe just leave the first column but let the others scroll).

Thank you

 

1

• 

  Thom Shackleford May 11, 2020 15:55

  Seems to have something to do with browser zoom settings. Experienced the same issue. When adjusted to 100% the horizontal scroll function no longer freezers the columns. 

  0

  Comment actions Permalink
• 

  Kyle White September 18, 2020 16:23

  It does appear to be related to browser, but not in this manner.  When you have dimension columns that do not fit in the width of your browser, then there will be no freezing.  If you have at least one value column in view, then they will freeze, and this creates quite a problem.  I have some dashboards where all of values columns scroll in a tiny sliver on the right of my screen.  This is quite useless.

  I would still prefer to have a design checkbox to freeze/ unfreeze dimension columns in pivot tables.  This appears to be the way the css is written for their p-dim class they add to each dimension field.

  0

  Comment actions Permalink

Please sign in to leave a comment.