https://bugs.documentfoundation.org/show_bug.cgi?id=162417
--- Comment #24 from Robert Lacroix <[email protected]> --- (In reply to Heiko Tietze from comment #22) > You can achieve this with the data field options. To stick with my example, > showing only two items from top keeps the PT height constant. > > Besides the questionable UX, isn't this what you want? If so, can we discuss > how to make this feature easier to access (I have to add the row to filters, > click options in data fields, change settings)? This is a good try at a workaround, but no. "Show Top N items" does constrain the PT dimensions, but it has a fatal side effect. "Show Top N items" selects the N field values which have the greatest total of their associated data. If a new (unexpected column for example) appears because of the unconditional setting of the new value's checkbox, then "Show Top N items" makes a choice among the N+1 columns now available for display and the lowest one is omitted. So when the new field value has a total which is greater than any of the others, one of the previously displayed columns is omitted from the PT and the columns are rearranged in alphabetical order. This is bad news for any formula which refers into the data in the PT. -- You are receiving this mail because: You are the assignee for the bug.
