Skip to main content
Solved

Pivot Table Formatting - Column Pixel Width for "Values"

  • April 3, 2023
  • 1 reply
  • 143 views

AWelty24
Jr Varsity II
Forum|alt.badge.img

It looks like Acumatica allows us to control the pixel width of rows & columns as they appear on the screen for pivot tables.

Is there also a way we can control the pixel width of the cells in which Acumatica displays the column values?

In my example, we’re just displaying a single- or double-digit integer value in the “values” area; and the end users have some screen space constraints. So they want to see MORE columns in a single screen.

However, when I adjust the pixel width for the Columns, it only adjusts the column headers. And when I adjust the pixel width for Values, there is no change. Ideally I’d be able to control the column width for the cells that display ‘values’. I have it set to 2 px right now and it looks exactly the same as when I set it to 200 px.

The highlighted area is the one I’m trying to shrink: 

 

And here’s where I’m attempting to control that: 

 

 

Would be open to any suggestions on this.

Acumatica 2022 R2
Build 22.204.0019

Best answer by hkabiri

@AWelty24  This is actually only for the user which is logged in. You probably have adjusted the column width while on the pivot table and system stored your user preference on a table called PivotFieldPreferences.

If you query this table you can see the user logged in as the owner and list of fields and preferred sorting or width.

However, for other users, it follows the default settings.

View original
Did this topic help you find an answer to your question?

1 reply

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 226 replies
  • Answer
  • April 5, 2023

@AWelty24  This is actually only for the user which is logged in. You probably have adjusted the column width while on the pivot table and system stored your user preference on a table called PivotFieldPreferences.

If you query this table you can see the user logged in as the owner and list of fields and preferred sorting or width.

However, for other users, it follows the default settings.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings